原因:此数据库是用sql语句备份而来,引发的错误,原备份和还原的sql语句如下:
--备份
BACKUP DATABASE LeaRunFramework_Base_2016 TO DISK = 'c:\DB_BACKUP\LenborMealOrder_Base_2017.bak'
--还原
RESTORE DATABASE Members_01 FROM DISK = 'c:\DB_BACKUP\LenborMealOrder_Base_2017.bak'
WITH MOVE 'LenborMealOrder_Base_2017' TO 'c:\DB_BACKUP\Members_01.mdf',
MOVE 'LenborMealOrder_Base_2017_log' TO 'c:\DB_BACKUP\Members_01.ldf'
- 查找该数据的逻辑文件名,通过下面的语句即可查出,再修改还原语句中的名称即可。
restore filelistonly from disk='c:\DB_BACKUP\LenborMealOrder_Base_2017.bak'
2、 修改后的还原语句如下:
--还原
RESTORE DATABASE LenborMealOrder_Base_2017 FROM DISK = 'c:\DB_BACKUP\LenborMealOrder_Base.bak'
WITH MOVE 'LeaRunFramework_Base_2016' TO 'c:\DB_BACKUP\LenborMealOrder_Base_2017.mdf',
MOVE 'LeaRunFramework_Base_2016_log' TO 'c:\DB_BACKUP\LenborMealOrder_Base_2017.ldf'