How to restore the master database (Transact-SQL)

How to Install SQL Server 2000

previous page next page
How To

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)

previous page start next page