SQL Server Database Restore (do not imitate!) ）

1. Always have backup bak file before restore

2. When restoring data, prompt the following information:

Once the database is accessed, disconnect all connections.

The disconnection method is as follows:

Click to open link

Then, then found the wood has the effect ... or a hint of error

In fact, I tried to take the database offline, can be offline all the time, the period stopped offline, not even the database ....

3, because no one at night in use, so I can guarantee that the database I backed up is up-to-date, and then I think of an evil method, delete the database

But at the time of deletion, prompt the following information:

4, I am angry, I went to restart the database service

5. After the reboot is complete, delete the database successfully.

6, restore the database, such as:

Get!

Small bet

1, the formal environment do not imitate!

formal environment do not imitate!

Formal environment do not imitate!

Important thing to say three times!!!

2, the formal environment can be consulted: Click to open the link

However, the above connection was found after I deleted it, so there is no verification.

3, the purpose of writing this article is to record: the target database can actually be input, but not necessarily pull down to choose! Hey...

Copyright: jiankunking Source: http://blog.csdn.net/jiankunking This article is copyright to the author and Csdn, Welcome to reprint, but without the consent of the author must retain this paragraph, and in the article page obvious location to the original connection.

SQL Server Database Restore (do not imitate!) ）