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

8

If you're not using transaction log backups, then you don't need FULL recovery mode. It's that simple.

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 '16 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.