Shulou(Shulou.com)06/01 Report--

Knowledge part

System database: SQL Server 2008 R2 includes four system databases by default, namely, master, model, msdb, and tempdb. The master database is used to record all system-level information, all login accounts and system configuration settings. At the same time, all other database information is recorded, including the location of the database file, as well as the initialization information of all SQL Server. If there is a problem with the master database, it will lead to the collapse of the whole database, unable to use, and cause huge losses to the enterprise. So it is necessary to do a good backup of master database as a qualified DBA.

Operation part

1. First of all, we create an experimental database "database" and create a table "student" in the database to test whether the restore is successful.

2. Create a new login name

3. In the first step, we find "Server object"-"backup device"-"New backup device"

4. Name the backup device

5. Then right-click the newly created "backup device"-"backup Database"

6. Select backup "master"

7. After completion, we begin to prepare to simulate the failure of the master of the database. First stop the SQL Server (MSSQLSERVER) service.

8. Then find the master database in the path below and delete it.

9. Log in to the SSMS tool after deletion, there will be an error in the following figure. At this point, the database cannot be used.

10. Recovery part. We insert the SQL Server 2008 R2 CD.

11. Run cmd, and enter the command in the following figure-enter to complete.

12. Open Service Management-locate the SQL Server (MSSQLSERVER) service and edit its properties. Enter "- c-m" in the startup parameters to start the service. Logging in to SQLServer using the SSMS tool again will enter single-user mode.

13. Enter "." in the server name when entering single-user mode.

14. Find the location of the backup file.

15. Enter the following statement in the new query and execute it to restore the master database

16. Find the service again, leave the startup parameters blank, and restart the service

Then log in to SSMS again and find that the database is ready for re-use.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.