如何将SQL Server 2012数据库复制到localdb实例? [英] How do I copy SQL Server 2012 database to localdb instance?

问题描述

我希望将SQL Server 2012 Standard数据库复制到我的localdb实例.我尝试了向导，该向导抱怨localdb不是SQL Server 2005或更高版本的Express实例.我也做了备份/还原，但是在我的localdb中还原后，出现以下错误...

I'm looking to copy a SQL Server 2012 Standard database to my localdb instance. I've tried the wizard which complains that localdb isn't a SQL Server 2005 or later express instance. I also did a backup/restore but upon the restore in my localdb I get the following error...

运行此...

RESTORE DATABASE CSODev
FROM DISK = 'C:\MyBckDir\CSODev.bak'
WITH MOVE 'CSOdev_Data' TO 'C:\Users\cblair\CSOdev_Data.mdf',
MOVE 'CSOdev_Log' TO 'C:\Users\cblair\CSOdev_Log.ldf',
REPLACE

我收到错误消息...

Error message I get...

已处理数据库'CSODev'的8752页，文件1上的文件'CSOdev_Data'.
已处理数据库"CSODev"的5个页面，文件1上的文件"CSOdev_Log".

Processed 8752 pages for database 'CSODev', file 'CSOdev_Data' on file 1.
Processed 5 pages for database 'CSODev', file 'CSOdev_Log' on file 1.

消息1853，级别16，状态1，第1行
找不到逻辑数据库文件"CSOdev_Log".指定文件的完整路径.
消息3167，第16级，状态1，第1行
RESTORE无法启动数据库'CSODev'.
消息3013，第16级，状态1，第1行
RESTORE DATABASE异常终止.

Msg 1853, Level 16, State 1, Line 1
The logical database file 'CSOdev_Log' cannot be found. Specify the full path for the file.
Msg 3167, Level 16, State 1, Line 1
RESTORE could not start database 'CSODev'.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

数据库最终以正在恢复挂起"模式.日志文件似乎有问题.我尝试了2种不同的备份，以防其中一种损坏.

The database ends up in "Recovery Pending" mode. It seems like it has issues with the log file. I have tried 2 different backups in case one was just corrupted.

推荐答案

有

There is known limitation (a real bug, in fact) for localDB. It will fail any RESTORE with MOVE whenever your database files are located in different folders.

您必须在原始文件夹中还原(不能移动).如果您需要伪造drive:/path，请使用SUBST之类的cmd工具.

You have to restore in the original folders (no MOVE). Use cmd tool such as SUBST if you need to fake a drive:/path.

这篇关于如何将SQL Server 2012数据库复制到localdb实例?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！