Quick Scan Report – Master Database Not in Simple Recovery Mode

If the Quick Scan Report has detected that the Master Database Not in Simple Recovery Mode, this is something that should be corrected by switching the master database to simple recovery mode.

Why? There is not reason to run the master database in anything but simple recovery mode because there is not restore option for the master database that supports anything other than a full recovery. Transaction log backups, or even the tail of the log transaction log backup don’t make any sense for the master database.

 

However that being said there is one way that you could make use of a transaction log backup for master. You could restore the master database to another database, then perhaps copy some of the details from the renamed master database back to the original.

Related Links:

 

 


Enroll Today!
SteveStedman5
SteveStedman5
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!