SQLserver2008 database backup and restore issues (restore is a must have a full backup)

First of all, I want to explain that you must have a full database backup, the following restore tutorial, only useful, if other problems, please search other Daniel's solution, this method is only suitable for beginners.

This connection is the webmaster adult's unusual recovery method, has the question to study http://www.cnblogs.com/dudu/archive/2011/10/15/sql_server_recover_deleted_records.html oneself

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!

SQLserver2008 database backup and restore issues (restore is a must have a full backup)