10

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.)

Improve this question

1 Answer 1

Reset to default
9

If you're not taking transaction log backups, you don't want to use the FULL recovery model. It's that simple.

SQL Server Database Properties - ReportServer Database

  • 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.
Improve this answer
1
  • you don't only need it, you actually should not use FULL mode if you are not backing your logs. Otherwise the .ldf file will eventually fill your hdd
    – greg121
    Mar 9, 2016 at 10:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.