patternsqlMinor
Is it safe to change the Recovery Model of SSRS database ReportServer to SIMPLE?
Viewed 0 times
ssrsthesimplechangereportserverdatabaserecoverysafemodel
Problem
I'm changing the recovery model of ReportServer database from FULL to SIMPLE.
Is there any reason why i would not want to do this? Besides the obvious answer of losing point-in-time recovery? (i am not doing transaction log backups on this database anyways.)
Is there any reason why i would not want to do this? Besides the obvious answer of losing point-in-time recovery? (i am not doing transaction log backups on this database anyways.)
Solution
If you're not taking transaction log backups, you don't want to use the FULL recovery model. It's that simple.
- Set the Recovery model to Simple and click OK to change.
- It is recommended to perform a FULL backup of the database after changing the Recovery model.
Context
StackExchange Database Administrators Q#1313, answer score: 9
Revisions (0)
No revisions yet.