Restoring the master Database

You have probably guessed by now that the master database is definitely not just another database and is required to allow SQL Server to start, stop, and run as a service. The master database stores all the information about the users and databases on your system. Restoring the master database can be performed one of two ways. If you are able to start SQL Server and you find out that the master database is damaged, you can restore the database from a previous backup just as you would with a regular user database. If you have performed any operations that made modifications to the master database after the backup was performed, you might have to perform the operations again, for example, in the case of adding or deleting ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition 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.