ERROR MESSAGE #2 Server: Msg 3241, Level 16, State 7, Line 1 The media family on device [path of backup] is incorrectly formed. Error when restoring SQL2000 backup to SQL2005 Rate Topic Display Mode Topic Options Author Message Mike GrayMike Gray Posted Wednesday, January 25, 2006 3:45 AM Forum Newbie Group: General Forum Members The server supports version 539 and cannot restore or upgrade this database. Is it a beta release or something? check over here
Error messages below: Attach database failed for Server 'Development\SQLSERVER'. (Microsoft.SqlServer.Smo) Database 'PS_EmpData' cannot be upgraded because its non-release version (539) is not supported by this version of SQL Server. When I attempt to restore the 2000 backup to 2005 via the 2005 interface I get the error :The backed-up database has on-disk structure version 611. Monday, January 15, 2007 4:18 PM Reply | Quote 0 Sign in to vote hi there i'm facing the same problem... 1] I had SQL 2000 database dbTest... 2] attached that You cannot post or upload images.
If you need immediate assistance please contact technical support. It will work. Post #254506 Curtis TamanahaCurtis Tamanaha Posted Wednesday, February 1, 2006 10:45 AM SSC Rookie Group: General Forum Members Last Login: Monday, March 2, 2015 12:57 PM Points: 31, Visits: 72 You
more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed We can't restore the backups taken in Newer version of SQL Server instance on older version of SQL Server. You cannot delete your own topics. Sql Server 2000 Download Posted by s vr at 9:13 PM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: Administration, History, MSSQL Admin, Rename database, SQL 2000/2005/2008/2008R2/2012/2014, SQL DBA, SQL Server 2012, venkatsangusqldba.blogspot.in Newer
You may download attachments. Database Cannot Be Upgraded Because Its Non-release Version (539) However, just to help out anyone reading this, I ended up performing an upgrade from SSEE to the full-blown server install. But after SSIS came I have preferred this in the Copy Database Task. Then I am able to run that restore script on the new server.
Search All Articles About Us Company Partners Resources Knowledge Base Download Software Technical Documentation Training and Certification Professional Services Related AppAssure Licensing Portal Licensing Assistance Renew Support Social Facebook Google+ LinkedIn It can only read 539 and below. Cannot Open Database Version 539. Upgrade The Database To The Latest Version Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. Attach Sql 2000 Database To Sql 2012 have another Dr.
it got changed in the file copy). SQL Server cannot process this media family. You cannot delete other events. The server supports version 539 and cannot restore or upgrade this database.RESTORE FILELIST is terminating abnormally. (Microsoft SQL Server, Error: 3169)Is there ANY way I can restore this backup to my Sql Server 2014 Compatibility Level
SQL Server 2008 R2 to SQL Server 2005 Server: Msg 3241, Level 16, State 7, Line 1 The media family on device [path of backup] is incorrectly formed. That also works for me. Server: Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. SQL Server cannot process this media family.
That just happened to me also. Please contact Support for further assistance. I think it's the objects/data migration module 0 LVL 2 Overall: Level 2 MS SQL Server 1 MS SQL Server 2008 1 Message Author Comment by:RakeshBhandari2010-10-11 Comment Utility Permalink(# a33874284)
Click continue to be directed to the correct support content and assistance for *product*. Vincent & Grenadines Suriname Swaziland Sweden Switzerland Tanzania Thailand Togo Trinidad y Tobago Turkey Turks & Caicos Islands Uganada Ukraine United Kingdom United States Uruguay US Virgin Islands Venezuela Yemen Zambia Post #488866 « Prev Topic | Next Topic » Permissions You cannot post new topics. If anyone has a suggestion, I'd appreciate it.Here is what Microsoft says: "Media that is formatted with SQL Server 2005 cannot be interpreted by SQL Server version 7.0 and releases of
errrrrr.. However, just to help out anyone reading this, I ended up performing an upgrade from SSEE to the full-blown server install. SQL Server 2008 to SQL Server 2000 Server: Msg 3169, Level 16, State 1, Line 1 The backed-up database has on-disk structure version 655. Then I went to the original server used the wizard to genearate the restore script and modified the location of the files as per the new environment.
ERROR MESSAGE #4 Server: Msg 3241, Level 16, State 7, Line 1 The media family on device [path of backup] is incorrectly formed. Then I restored the databases normally.have another Dr. The server supports version 539 and cannot restore or upgrade this database. You cannot post topic replies.
I have attached many 2008R2 DB's to 2012. Monday, December 12, 2005 9:01 PM Reply | Quote 0 Sign in to vote You cannot restore/attach a database from Sql 2005 to Sql 2000, however you can move your datas All product and company names are trademarks or registered trademarks of their respective owners. Friday, October 09, 2009 12:49 AM Reply | Quote Moderator Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.
Server supports version 539 (30314) × Return Title Error: On-disk structure backup version 611. sql-server share|improve this question asked Jan 23 '13 at 16:26 user1968541 36112 migrated from stackoverflow.com Jan 23 '13 at 17:09 This question came from our site for professional and enthusiast programmers. Browse other questions tagged sql-server or ask your own question. Run DBCC CHECKTABLE on sysindexes.
If so restore this one and create an SSIS job on SQL 2008 with the COPY Database task. I happen to have 2000/2008R2/2012 all deployed, so I'm going to do a quick test and ensure the above works. SQL Server 2005 to SQL Server 2000 Server: Msg 3169, Level 16, State 1, Line 1 The backed-up database has on-disk structure version 611. Kitts & Nevis St.
up vote 7 down vote favorite 1 We have been asked to move from SQL Server 2008 R2 over to 2012, the installation completed a few hours ago.