SQL Server 2008 Database backup and restore (restore is required to have a full backup)

Transfer from LWCCC, SQLserver2008 database backup and restore issues (restore is a must have a full backup)

First of all, I want to explain that you have to have a full database backup, the following restore tutorial is useful.

This connection is a master of the abnormal recovery method, the actual combat SQL Server 2008 Database deleted Data Recovery

First, to learn to back up the database, select the need to back up the database, right-click the mouse, such as:

Second, after clicking Backup, for example, click OK:

Third, after the backup is restored, select the database, right-click the mouse.

Four, select the source device, click the right button to browse the folder, select the backup file.

Five, click OK, will be automatic restore, complete will be prompted, to be patient. Sometimes you will encounter error prompts, to see how the prompt is said, you can first try the following methods, cancel the use of other users of the database.

Six, the above operation is completed, repeat the previous restore operation, try again, if there are still problems, then take a look at the following method. First, delete the database you want to restore (full data backup must have Oh, or you will have a cup), do not blame me Oh! Right-click on the database directory to create a new database for restore (repeat the steps before you create it), or restore the database directly.

Seven, the name needs to input, and then repeat the previous restore steps, you can.

Eight, finally, to try, dare to try, it is possible to encounter a variety of problems in the process, the last one to delete the old database, re-restore a new database is my best way to use, no matter what problems can be done, but the premise is a complete database backup, be sure to remember, backup, Backup, and then back up! Data is life!

SQL Server 2008 Database backup and restore (restore is required to have a full backup)