SQL Server database master database recovery

SQL SERVERDatabaseMasterDatabase Recovery

First, the experimental steps probably

1 , first create a database and a table to be used for post-recovery validation.

2 , the Master The database is backed up well in advance.

3 , Simulation Master database Delete, shut down in service SQL Server service can then be removed Master database.

4 , restart SQL Server Service, found unable to start!

5 and rebuild the database.

6 , enter single-user mode, restore Master database.

7 , restart again, database and tables created before accessing the database are restored , found back to normal!

* : This case experiment environment is R2

Second, the experimental steps

1 , first create a database and a table to be used for post-recovery validation.

2 , the Master The database is backed up well in advance.

3 , Simulation Master database Delete, shut down in service SQL Server service can then be removed Master database.

4 . Restart the SQL Server service and discover that it cannot be started!

5 and rebuild the database.

5.1 ), insert SQL Server database disc, note the number of disk characters.

5.2 ), enter cmd , enter the code to rebuild the database.

6.1), single-user mode to start the SQL Server service

net start mssqlserver/m/s

6.2), copy the location path where the master database backup resides.

6.3 ), Credit connection SQL Server server instance, restoring after connection Master

7 , restart again, database and tables created before accessing the database are restored , found back to normal!

SQL Server database master database recovery