Overview
In order to be able to restore the MSDB database and not lose data, you should pick the proper recovery model for the MSDB database.
Explanation
What recovery model should the MSDB database have, and can the recovery model be changed?
The MSDB database ships in simple recovery model. This is usually acceptable, but depending on the recovery needs for the instance, it might need to be changed to full. Consider whether things like the SQL Server Agent job steps change often enough that point-in-time recovery is necessary. Be sure that if the recovery model is changed that log backups are scheduled at a regular interval.
Eric has been a SQL Server DBA and Architect in the legal, software, transportation, and insurance industries for over 10 years. Currently he is the Sr Data Architect for Squire Patton Boggs, a leading provider of legal services with 47 offices in 20 countries.
Eric is a 2018-2019 Idera Ace and has co-authored 2 Idera Whitepapers.
He has been a presenter at PASS Summit, IT/DevConnections, SQLSaturdays, the in.sight transportation conference, and the Ohio North SQL Server User’s Group.
- MSSQLTips Awards: Author of the Year Contender – 2021, 2022 | Trendsetter (25+ tips) – 2021
