Mssql Error 3169
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. I am glad that I
Restore Sql 2000 Database To Sql 2012
am able to get into unique situations and then resolve them too. And this the database was backed up on a server running version 8 is more of a diary of the error messages I am getting into. I was playing with my Demo database on SQL
Sql Server Version Numbers
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 The database was backed up on a server running version sql server 2014 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 msdn 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 Server 2008” (or appropriate version)Click on Next and finish to complete the process.Now you can use the generated script file and execute this against the SQL server 2008 instance t
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 6.2 million programmers, just like you, helping each other. Join them; it 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 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/ 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 http://stackoverflow.com/questions/15788624/restore-a-sql-server-2000-backup-on-sql-server-2012 Aaron Bertrand 165k18265320 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 165k18265320 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 a
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual http://database.ittoolbox.com/groups/technical-functional/sql-server-l/error-3169-on-restoring-database-220939 Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries MacProTX VoIP_News Inside-ERP I_am_the_dragon Inside-CRM maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Locutus Craig Borysowich Dennis Stevenson mircea_luca Richard DukeGanote iudithm Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk jakarman Adrian_Grigoriu knowscognosdoi COMPANIES GeoTrust Juniper Networks Silver Peak Sophos View All sql server Topics View All Members View All Companies Toolbox for IT Topics Database Groups Ask a New Question SQL Server The SQL Server group is a forum where peers share technical expertise, solve problems, and discuss issues related to Microsoft SQL Server. Home | Invite Peers | More Database Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds mssql error 3169 E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Error 3169 on restoring database Fred_vc asked Feb 28, 2003 | Replies (9) Trying to restore DB of SQL Server 2000 to sql server 7.0 Error 3169 : The backed-up database has on-disk structure version 539. The server supports version 515 and cannot restore or upgrade this database. Any help is welcome ! Best Regards, Vriendelijke groeten, Cordialement, Fred Join this group Popular White Paper On This Topic Beginner's Guide to ERP 9Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... hanishdesai replied Mar 5, 2007 Hi, You normally get this error when you take a backup in SQL Server 2000 and then try to restore that backup in SQL Server 7.0 SP2. The error