Change recovery model on the fly | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Change recovery model on the fly

Is it possible/will it cause any problems to change recovery model on the fly for a production database? —
Frettmaestro
"Real programmers don’t document, if it was hard to write it should be hard to understand"
Not as I aware it will cause any issues for a normal database. If the database is accessed more frequently and while the Tlog jobs are in process changing this option may cause issues. By using ALTER DATABASE statement you can set the recovery model :
ALTER DATABASE …..
… RECOVERY { FULL | BULK_LOGGED | SIMPLE } .. Refer to books online for more information.
_________
Satya SKJ
Moderator
SQL-Server-Performance.Com
Ok, thanx. I think I’ll wait until tonight just in case…don’t wanna risk anything… —
Frettmaestro
"Real programmers don’t document, if it was hard to write it should be hard to understand"
Also, it is recommended to take a full database backup after changing from Simple to FULL or viceversa
In any case BACKUP saves…. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
]]>