Problems restoring 2000 db to 2005
Hello,
I'm having a problem restoring a db from sql server 2000 to 2005. The db is around 4 gigs, and seems to restore fine on other 2000 servers, just not 2005. In the restore window, for some reason it sees the name as 'INCOMPLETE', when starting restore it will get error after about 20% complete:
System.Data.SqlClient.SqlError: The media family on device 'P:\MSOC_FULL.DMP' is incorrectly formed. SQL Server cannot process this media family. (Microsoft.SqlServer.Smo)
Any thoughts as to why the db would restore fine on 2000 but not 2005?
Thanks,
Adrian Crawford
First, please let us know what versions you are trying to move between (“select @@version” to get full info on both servers – the one that the backup was made on and the target server).
Next, try executing the restore commands directly in T-SQL window vs. using GUI, just to rule out the GUI as the problem:
RESTORE HEADERONLY
FROM DISK='P:\MSOC_FULL.DMP'
RESTORE VERIFYONLY
FROM DISK='P:\MSOC_FULL.DMP'
Alternatively, there may be multiple backups in the file, only some of which can be restored.
RESTORE VERIFYONLY
FROM DISK='P:\MSOC_FULL.DMP'
WITH FILE=2 -- this asks us to check the second backup in the file.
As we get more info we can give you a better answer.
Thanks to Steve Schmidt for helping to answer this post!
Thank you,
Boris.
Hey Boris, thanks for the response. The versions we are trying to move between are
SQL 2k SP3
to
Microsoft SQL Server 2005 - 9.00.1187.07 (Intel X86)
May 24 2005 18:22:46
Copyright (c) 1988-2005 Microsoft Corporation
Beta Edition on Windows NT 5.2 (Build 3790: )
I will try to run the restores from T-SQL as well.
Thanks,
Adrian
Could you provide output of HEADERONLY, VERIFYONLY commands on 2000 and 2005?
How did you generate this backup file?
Another possibility is that the backup file is corrupt. The error message is very generic to give you any additional information.
Yet another possibility is to contact customer support.
Boris.
