本文共 909 字，大约阅读时间需要 3 分钟。
Database YourDB has full backup YourBaackUpFile.bak. It can be restored using following two steps.
Step 1: Retrive the Logical file name of the database from backup.
RESTORE FILELISTONLYFROM DISK = 'D:BackUpYourBaackUpFile.bak'GOStep 2: Use the values in the LogicalName Column in following Step.----Make Database to single user ModeALTER DATABASE YourDBSET SINGLE_USER WITH ROLLBACK IMMEDIATE ----Restore DatabaseRESTORE DATABASE YourDBFROM DISK = 'D:BackUpYourBaackUpFile.bak'WITH MOVE 'YourMDFLogicalName' TO 'D:DataYourMDFFile.mdf',MOVE 'YourLDFLogicalName' TO 'D:DataYourLDFFile.ldf'
/*If there is no error in statement before database will be in multiuser mode. If error occurs please execute following command it will convert database in multi user.*/ALTER DATABASE YourDB SET MULTI_USER GO
本文转自today4king博客园博客，原文链接：http://www.cnblogs.com/jinzhao/archive/2012/10/17/2728018.html，如需转载请自行联系原作者