Overview
This section covers the best recovery model for the master database.
Explanation
The master database ships in simple recovery model, and that is generally acceptable. Since the data rarely changes and the database is backed up daily, adding point-in-time recovery is not necessary.
MSSQLTips.com delivers SQL Server resources to solve real world problems for DBAs, Architects, DevOps Engineers, Developers, Analysts, Cloud and Business Intelligence Pros – all for free. The content we serve is all human written and based on our authors’ real-world experience. Check out tips, articles, scripts, videos, tutorials, live events and more all related to SQL Server on-premises and in the cloud.
