How to restore the master database (Transact-SQL)

To restore the master database

Important The system administrator restoring the database backup must be the only person currently using the database to be restored.

1. Start Microsoft® SQL Server™ in single-user mode.
2. Execute the RESTORE DATABASE statement to restore the master database backup, specifying:
   • The backup device from where the master database backup will be restored.

Examples

This example restores the master database backup from tape without using a permanent (named) backup device.

USE master

GO

RESTORE DATABASE master

    FROM TAPE = '\\.\Tape0'

GO

See Also