O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required