RESTORE DATABASE [qbz] FROM DISK = N'H:\各药店数据备份\仟佰众数据备份\040517'
WITH FILE = 1, NOUNLOAD , STATS = 10, RECOVERY , REPLACE ,
MOVE N'scm_Data' TO N'D:\Microsoft SQL Server\MSSQL\Data\qgz_Data.MDF',
MOVE N'scm_Log' TO N'D:\Microsoft SQL Server\MSSQL\Data\qbz_Log.LDF'有这个改一下就OK了
WITH FILE = 1, NOUNLOAD , STATS = 10, RECOVERY , REPLACE ,
MOVE N'scm_Data' TO N'D:\Microsoft SQL Server\MSSQL\Data\qgz_Data.MDF',
MOVE N'scm_Log' TO N'D:\Microsoft SQL Server\MSSQL\Data\qbz_Log.LDF'有这个改一下就OK了
还有把MOVE 'WzzygsTest.mdf'
改为wzzygstest
把'WzzygsTest_Log.ldf'
改为wzzygstest_log
newdate_Log.Ldf看到这个没有
newdate_Data
newdate_Log
将这个改成你要的数所库名
一切OK,和我以样犯这样的错!!