Error 3169 The Backed
Contents |
SERVER - FIX Error 3169 - The database was backed up on a server running version January 9, 2016Pinal DaveSQL Tips and Tricks6 commentsAt this rate, I think I am going to exhaust the whole restore sql 2000 database to sql 2012 error set available in SQL Server. I am glad that I am
Sql Server Version Numbers
able to get into unique situations and then resolve them too. And this is more of a diary
Sql Server 2014
of the error messages I am getting into. I was playing with my Demo database on SQL Server 2016. Once done, I started restoring from the previous copy. But is
Msdn
failing with below error 3169:Msg 3169, Level 16, State 1, Line 1 The database was backed up on a server running version 13.00.0801. That version is incompatible with this server, which is running version 12.00.4213. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally.Then I realized that I have taken back-up from 13.00.0801 which is SQL Server 2016 and I was trying to restore on 12.00.4213 which is SQL Server 2014. The error message shows both versions, source and destination. So, it’s is clear that there is no direct way to downgrade from a higher version to a lower version and it would fail with an error message. Why? When an instance of SQL is upgraded, not only do the binaries for the database engine change, the schema level for the databases also changes. So it would not be possible to attach a database with a higher schema level to an instance on a lower version of SQL.What can be done? One possible approach is to manually export and import the data. You can follow the below steps:Create an Empty DatabaseIn Object Explorer, expand Databases, right-click a database, point to Tasks, and then click Generate Scripts. Follow the steps in the wizard to script the database objects.On the Choose Objects page, select “Sc
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2005 » Backups » Restore Dadabase From .bak Files 13 posts,Page 1 of 212»» Restore Dadabase From .bak Files Rate Topic Display Mode Topic Options Author Message sumanthchowdary.ksumanthchowdary.k Posted Thursday, July 17, 2008 10:00 AM Forum Newbie Group: General Forum Members Last Login: Monday, June 1, 2009 http://blog.sqlauthority.com/2016/01/09/sql-server-fix-msg-3169-level-16-state-1-the-database-was-backed-up-on-a-server-running-version-that-version-is-incompatible-with-this-server/ 10:25 PM Points: 5, Visits: 14 HiOne of my cus send the Database file(.bak only).He is using the SQL Server 2005 (Enterprise Edition).I am Unable ADD the Same to My SQL Server 2005(Developer Edition)I Tried Several Ways To add the Database BUT I am to DO SOI am Getting the ERROR MSG As"Msg 3241, http://www.sqlservercentral.com/Forums/Topic536132-357-1.aspx Level 16, State 7, Line 1The media family on device 'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Hills.bak' is incorrectly formed. SQL Server cannot process this media family.Msg 3013, Level 16, State 1, Line 1RESTORE DATABASE is terminating abnormally."Plz help to solve the issueThanks & RegardsSumanth Post #536132 MANU-J.MANU-J. Posted Thursday, July 17, 2008 11:10 AM SSCommitted Group: General Forum Members Last Login: Thursday, May 22, 2014 7:04 AM Points: 1,688, Visits: 8,766 Whats the output of restore verifyonly fom disk='Backupfilenamewithpath'?Manu Post #536180 Carl FederlCarl Federl Posted Thursday, July 17, 2008 11:31 AM SSCrazy Group: General Forum Members Last Login: Tuesday, September 20, 2016 9:44 AM Points: 2,316, Visits: 4,345 The backup file may be corrupted such as by FTPing with char mode instead of binary and can be checked by running:RESTORE VERIFYONLYfrom disk = 'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Hills.bak'Your version of SQL Server may be a lower version than the client's and a restore to a lower version is not supported. The version u
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting http://stackoverflow.com/questions/15788624/restore-a-sql-server-2000-backup-on-sql-server-2012 ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a http://www.tek-tips.com/viewthread.cfm?qid=134577 minute: Sign up Restore a SQL Server 2000 backup on SQL Server 2012 up vote 24 down vote favorite 4 I have got following error message while restoring a backup from SQL Server 2000 to the latest version. I do not sql server know the old version, now I am using SQL Server 2012 (11.0.3128.0). The error message is: Msg 3169, Level 16, State 1, Server FF101, Line 1 The database was backed up on a server running version 8.00.0760. That version is incompatible with this server, which is running version 11.00.3128. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. sql-server sql-server-2000 sql-server-2012 share|improve this question edited Apr 3 '13 at 13:31 error 3169 the Aaron Bertrand 165k18263320 asked Apr 3 '13 at 13:25 user2053420 2 “The database was backed up on a server running version 8.00.0760. That version is incompatible with this server, which is running version 11.00.3128.” –CBroe Apr 3 '13 at 13:28 add a comment| 1 Answer 1 active oldest votes up vote 37 down vote accepted You are trying to restore a SQL Server 2000 database on SQL Server 2012. This is not supported. You will need to restore your database on an instance of SQL Server 2005, 2008 or 2008 R2 first, then back it up from there, then restore the new backup on SQL Server 2012. Microsoft explains this here. share|improve this answer edited Feb 5 at 12:08 answered Apr 3 '13 at 13:29 Aaron Bertrand 165k18263320 Thanks, I will check. –user2053420 Apr 3 '13 at 15:07 4 @Johnny_D No. Download an eval (here's a link for 2008), install a new named instance, restore your database, back it up, then uninstall the eval. –Aaron Bertrand Jan 14 '14 at 14:38 1 Here's a script that among other things automates the restore-backup cycle you have to perform: gist.github.com/timabell/d43b21f889bd9dada355 (skip to proc #upgradeBackupFile) –Tim Abell Jan 27 '15 at 23:12 1 I owe you a drink, wonder why Microsoft didn't bother with such a simple statement ! –Heider Sati Dec 14 '15 at 11:00 1 @Heider Because they don't think anybody is (or should be) running 2000
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Microsoft SQL Server: Programming Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesMicrosoft SQL Server: Programming Forum Error 3169 when restoring thread183-134577 Forum Search FAQs Links MVPs Error 3169 when restoring Error 3169 when restoring bashboy (Programmer) (OP) 13 Sep 01 11:53 I have a backup file that was created on an SQL 2000 Professional version server and I tried to restore this backup to an SQL 7 server and got the following error message:Error 3169: The backed up database has on-disk structure version 539.The server supports version 515 and connot restore or upgrade this database.Backup or restore operation terminated abnormally. Can anyone help me resolve this problem.I have done backups and restores from 2000 to 7 before without this problem.Thanks, RE: Error 3169 when restoring tlbroadbent (MIS) 13 Sep 01 16:40 I'm suprised that you say you have restored a SQL 2000 backup to SQL 7. All SQL documentation indicates this is not possible. The formats changed from SQL 7 to SQL 2000. SQL 7 cannot rea