March 7, 2010 at 10:37 pm
😉
Dear Sir,
I am in a great trouble, I have taken backup on sql server 2005 and want to restore back up in sql server 2000 plat form,
when I restoring the backup the it giving a Error Message which is mentioned below :
Server: Msg 3241, Level 16, State 73, Line 1
The media family on device 'D:\THIRANI\SHADMIN_backup_201003060930.bak' is incorrectly formed. SQL Server cannot process this media family.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Hence, What I do now, Is it possible to restore the backup from upper version to lower version.
Please help me,
Thanking You
Debasis Bag
March 7, 2010 at 10:49 pm
You cannot restore a SQL 2005 database directly as SQL 2000.
March 8, 2010 at 12:37 am
You'll need to script out all the objects, export all the data and recreate the database on SQL 2000.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 8, 2010 at 12:51 am
Even when you script it out, the Scripts coming from SSMS will be SQL 2005 compatible by default. Use the option Script for version 'SQL Server 2000'
Regards,
Raj
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply