关于sql server 2008 r2:错误:指定的转换无效。 (SqlManagerUI)
[删除(380066935@qq.com或微信通知)]
Use Master
Go
RESTORE DATABASE YourDB
FROM DISK = 'C:\\YourBackUpFile.bak'
WITH MOVE 'YourMDFLogicalName' TO 'D:\\Data\\YourMDFFile.mdf',--check and adjust path
MOVE 'YourLDFLogicalName' TO 'D:\\Data\\YourLDFFile.ldf'
RESTORE VERIFYONLY FROM DISK = N'd:\\yourbackup.bak'
如果出现类似以下错误:
RESTORE HEADERONLY FROM DISK = N'd:\\yourbackup.bak'
意味着您的备份已损坏或来自较新版本。
我从SQL Server 2012恢复到SQL Server 2008 R2时遇到了类似的错误"指定的转换无效"
首先,我得到了MDF和LDF名称:
RESTORE FILELISTONLY
FROM DISK = N'C:\\Users\\dell laptop\\DotNetSandBox\\DBBackups\\Davincis3.bak'
GO
RESTORE DATABASE Davincis3
FROM DISK = 'C:\\Users\\dell laptop\\DotNetSandBox\\DBBackups\\Davincis3.bak'
WITH
MOVE 'JQueryExampleDb' TO 'C:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.MSSQLSERVER\\MSSQL\\DATA\\Davincis3.mdf',
MOVE 'JQueryExampleDB_log' TO 'C:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.MSSQLSERVER\\MSSQL\\DATA\\Davincis3.ldf',
REPLACE
GO