mssql2008 Database Restore Backup Tutorial

I. Restoring the database

Many programs need to be paired with the MSSQL database, and today we are going to learn how to restore the backup operations to the database. Take the MSSQL 2008 database to restore the backup bak file as an example:

After we landed into MSSQL 2008, right-click the database and select Restore Database

Enter the restore interface, such as

1. Select the database you want to restore, the target database you are restoring can be restored to the database you already have or you can create a new name, the restore will naturally appear with your new database name data.

2. The source device is the file of the database you are about to restore.

3. Select the backup set to use for restore. Otherwise you will be prompted to confirm that you must select the original source.

Click OK after checking, prompt to restore success, and then go back to check the database can be found that the database has been restored.

Second, the database backup:

Select the database that we want to back up---Right-click---task---backup.

Eject Backup Database dialog box

Add select "Where to back up", that is, the backup files are placed in that directory, and finally you can communicate qq:2881064157

mssql2008 Database Restore Backup Tutorial