MYSQL的逻辑文件名已经被用,sql – 错误 – 逻辑文件不是数据库的一部分 使用RESTORE FILELISTONLY列出逻辑文件名...

请运行下面的sql并检查逻辑名称

RESTORE FILELISTONLY

FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SS2008\MSSQL\Backup\Northwind.bak'

然后在下面的脚本中替换由RESTORE FILELISTONLY显示的逻辑名称

--If database already exists do not restore

IF DB_ID('Northwind') IS NULL

BEGIN

RESTORE DATABASE [Northwind]

FILE = N'Northwind_Data'

FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SS2008\MSSQL\Backup\Northwind.bak'

WITH

FILE = 1, NOUNLOAD, STATS = 10,

MOVE N'YOUR logical name of data file as shown by RESTORE FILELISTONLY command'

TO N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SS2008\MSSQL\DATA\Northwind.mdf',

MOVE N'YOUR logical name of Log file as shown by RESTORE FILELISTONLY command'

TO N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SS2008\MSSQL\DATA\Northwind_0.LDF'

END