SQL Server 2012 Database restore operations

Description: I was doing this restore database because the backed up database is not the same server as the restored database. There are some differences (specific differences I will list below) when the default click action is error so this document is listed by way. See the Friends Please be sure to carefully look at my operation of the real case:

The backup database has the following differences from the restored database:

2. Different servers

4. Different DB instance names

6. Different Database storage directories

   
   

8. 650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M02/83/86/wKiom1d08Vfgv57yAACLGdlAuVY829.png-wh_500x0-wm_3 -wmp_4-s_882942548.png "style=" Float:none; "title=" 1.png "alt=" Wkiom1d08vfgv57yaaclgdlauvy829.png-wh_50 "/>

10. 650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M00/83/85/wKioL1d08Vih1QysAACJLNeyFTI608.png-wh_500x0-wm_3 -wmp_4-s_1238580184.png "style=" Float:none; "title=" 2.png "alt=" Wkiol1d08vih1qysaacjlneyfti608.png-wh_50 "/>

12. 650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M00/83/86/wKiom1d08ViRrAKXAACtAe0W5Ik370.png-wh_500x0-wm_3 -wmp_4-s_2902756773.png "style=" Float:none; "title=" 3.png "alt=" Wkiom1d08virrakxaactae0w5ik370.png-wh_50 "/>

This article from "behind the scenes Operation" blog, declined reprint!

SQL Server 2012 Database restore operations