Error 3169 Sql 2008
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 error set available in SQL Server. restore sql 2000 database to sql 2012 I am glad that I am able to get into unique situations and
Sql Server Version Numbers
then resolve them too. And this is more of a diary of the error messages I am getting into. I sql server 2014 was playing with my Demo database on SQL Server 2016. Once done, I started restoring from the previous copy. But is failing with below error 3169:Msg 3169, Level 16, State 1, Line 1
Msdn
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 “Script entire database and database objects”.On the Set Scripting Options page, select Save scripts to a specific location.Select the Advanced button; under “Types of data to script” select “Schema Only” and under “Script for server version” select “SQL Se
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 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 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/ only takes a 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 know the old version, now I am using SQL Server 2012 (11.0.3128.0). The error message is: Msg http://stackoverflow.com/questions/15788624/restore-a-sql-server-2000-backup-on-sql-server-2012 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 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
Receive the following errors when trying to restore a SQL database: ERROR MESSAGE #1 Msg 3169, Level 16, State 1, Line 1 The database was backed up on a http://buildingskb.schneider-electric.com/view.php?AID=5679 server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that http://blog.sql-assistance.com/index.php/problem-restoring-a-sql-server is compatible with this server. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. ERROR MESSAGE #2 Server: Msg 3241, Level 16, State 7, Line 1 The sql server media family on device [path of backup] is incorrectly formed. SQL Server cannot process this media family. Server: Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. ERROR MESSAGE #3 Server: Msg 3169, Level 16, State 1, Line 1 The backed-up database has on-disk structure version 661. The server supports version 539 and cannot restore or upgrade this database. Server: error 3169 sql Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. ERROR MESSAGE #4 Server: Msg 3241, Level 16, State 7, Line 1 The media family on device [path of backup] is incorrectly formed. SQL Server cannot process this media family. Server: Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. ERROR MESSAGE #5 Server: Msg 3169, Level 16, State 1, Line 1 The backed-up database has on-disk structure version 655. The server supports version 539 and cannot restore or upgrade this database. Server: Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. ERROR MESSAGE #6 Server: Msg 3169, Level 16, State 1, Line 1 The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database. Server: Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. Product Line TAC I/NET, TAC Vista, Other Environment SQL Server 2008, SQL Server 2005 and SQL Server 2000 Enterprise, Standard, Express, MSDE Cause You cannot restore a backup created with a newer version of SQL Server on an instance r
14926 views Categories: Errors, SQL Server Problem When trying to restore a backup taken on SQL Server 2000 on a SQL Server 2012 the following error appears: Msg 3169, Level 16, State 1, Line 2 The database was backed up on a server running version 8.00.0818. That version is incompatible with this server, which is running version 11.00.3000. 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 2 RESTORE DATABASE is terminating abnormally. The problem is that on a SQL Server 2012 instance you cannot restore a SQL Server 2000 backup. Practically on SQL Server 2012 you can restore backups taken on SQL Server 2005 or later. Solution This situation can be avoided by performing the following steps: Restoring the SQL Server 2000 backup on SQL Server 2005 or 2008 Set compatibility level to90 (SQL Server 2005) or 100(SQL Server 2008 / SQL Server 2008 R2) Backup the same database and restore it on the SQL Server 2012. Currently 4.13/51 2 3 4 5 i Permalink 2 comments Comment from: Android Training in Chennai [Visitor] Hi this is Kathiresan i am having 3 years of experience as a dot net developer and i am certified. i have knowledge on OOPS concepts in .NET but dont know indepth. After learning android will be enough to get a good career in IT with good package? and i crossed http://www.besanttechnologies.com/training-courses/android-training-institute-in-chennai website where someone please help me to identity the syllabus covers everything or not?? Thanks, kathiresan 02/13/15 @ 10:48 Comment from: Yashika [Visitor] I'm very glad when read your article. It's easy to understand and very useful for newbie as me. Thank you so much and wish you happyhttp://www.aimitacademy.com/android-training-in-chennai/ 05/17/16 @ 16:29 Comment feed for this postLeave a comment Name: Email: Your email address will not be revealed on this site. Comment text: Options: Auto-BR (Line breaks become
) Remember me (For my next comment on this site) Allow message form (Allow users to contact me through a message form -- Your email will not be revealed!) DBA BlogUsef