How to set the recovery mode to SIMPLE on the Enterprise
Manager? If not, what is the SQL commend that could set
the Recovery mode to simply and bring it back? Tks!In the Enterprise Manager, you right click on the database, select
properties, then select the options tab, then select sinple in the recover
options drop down list.
To set the database to simple recovery in t-sql, use the alter database
command, eg:
alter database [mydb] set recovery simple
Regards,
Greg Linwood
SQL Server MVP
"KL" <anonymous@.discussions.microsoft.com> wrote in message
news:00c401c3c746$2e42be30$a601280a@.phx.gbl...
> How to set the recovery mode to SIMPLE on the Enterprise
> Manager? If not, what is the SQL commend that could set
> the Recovery mode to simply and bring it back? Tks!
No comments:
Post a Comment