Is there a problem with the reportservertempdb recovery model being "full"?

Question

Is there a problem when I changed the reportservertempdb recovery model? I changed it from simple to full.

Answer 1

No, there is not problem to set the recovery model of ReportServerTempDB to full; as long as you frequently run a log backup of it to release VLF, otherwise the log file of the DB keeps growing until the disk is full.

Answer 2

Hi @배 선정

Typically, a database uses the full recovery model or simple recovery model. A database can be switched to another recovery model at any time.

Here are the recommendations after switching from the simple recovery model:

• Immediately after switching to the full recovery model or bulk-logged recovery model, take a full or differential database backup to start the log chain.

Note: The switch to the full or bulk-logged recovery model takes effect only after the first data backup.

• Schedule regular log backups, and update your restore plan accordingly.

Important: Back up your logs. If you do not back up the log frequently enough, the transaction log can expand until it runs out of disk space!

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.