Restoring the master Database
The master database is the most important database in the SQL Server database management system. 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 might 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 back up master only by using a full backup. As a result, no differential or transaction log backups will be available. This means you might not be able to restore ...
Get Microsoft® SQL Server® 2008 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.
