Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to restore SQL Server 2008 database manually". In daily operation, I believe many people have doubts about how to restore SQL Server 2008 database manually. The editor consulted all kinds of information and sorted out simple and easy-to-use methods of operation. I hope it will be helpful for you to answer the doubt of "how to restore SQL Server 2008 database manually". Next, please follow the editor to study!

1. Click [start]-[Program]-[Microsoft SQL Server 2008]-[SQL Server Management Studio], as shown below

two。 The connection interface of SQL Server 2008 database appears, select the "database engine" server type, server name, authentication mode, enter the login name and password of the database, click the "Connect" button, and the management interface of SQL Server 2008 appears. Right-click "New Database" and click the New Database dialog box, as shown in the figure:

3. Enter the database name, such as db_platformesb_main, and then click the "OK" button to complete the addition of the database.

4. Right-click the db_platformesb_main database, select * * Task * *-> * * restore * *-> * * Database * * option, and the dialog box for restoring the database appears. As shown in the figure:

5. Select "Source device", click the [Browse] icon, and the dialog box interface for the specified backup appears. Select the "File" backup media, click the "add" button, the dialog box to locate the backup file appears, select the original backup file to be restored, confirm it, click the "OK" button, and the backup file will be added to the table box of the backup location. Click the "OK" button.

6. For the backup files that need to be restored, tick "√" in front, click the "options" menu, select "overwrite existing database" and "prompt between restoring each backup", other settings remain unchanged, click the "OK" button. Complete the restore operation of SQL Server 2008 database.

At this point, the study on "how to restore SQL Server 2008 database manually" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.