How to restore the master database (Transact-SQL)

To restore the master database

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

RESTORE

Restoring the master Database from a Current Backup

How to start the default instance of SQL Server in single-user mode (Command Prompt)