HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Is it safe to change the Recovery Model of SSRS database ReportServer to SIMPLE?

Submitted by: @import:stackexchange-dba··
0
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.)

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.