Restoring the Master Database
The master database is the most important database on SQL Server. This database stores information about all the databases on the server, server configuration, server logons, and other important information. If master gets corrupted, operations on the server may grind to a halt, and you will have to recover master using one of two techniques.
If you can start SQL Server, you can restore master from backup using a process similar to what you would use to restore any other database. To do this, complete the following steps:
You can only back up master using a full backup. As a result, no differential or transaction log backups will be available. This means you may not be able to restore master exactly as it was before ...
Get Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
