Error 3169 Sql Server 2008
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: SQL Server Backup & Restore Error: That version is incompatible with restore sql 2000 database to sql 2012 this server SQL Server > SQL Server High Availability and Disaster Recovery
Sql Server Version Numbers
Question 0 Sign in to vote Hi Team, I am having one issue ... Actually One of my server sql server 2014 having Database SQL Server which has around 5 GB of Backup file (One Database) now, I need to restore that on another Server of SQL. I have created blank database and msdn try to restored that.. but it gives me an error like The Database was backed up on a server running version 10.50.1617. That version is incompatible with this server, which is running version 10.00.2531 TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore failed for Server 'C55307110\SHAREPOINT'. (Microsoft.SqlServer.SmoExtended) The database was backed up on a server running version 10.50.1617. That version is incompatible with this server, which is running version 10.00.2531. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3169) This activity is the part for SharePoint 2007 to SharePoint 2010 Migration process. So, Please let me know if possible very conclusive steps or help or reference here.... Thanks & Regards, Brijesh Shah Thursday, March 01, 2012 11:32 AM Reply | Quote Answers 1 Sign in to vote 10.00.2531 is SQL Server 2008. Not SQL Server 2008 R2. You need SQL Server 2008 R2 to be able to restore that backup. 10.0 is 2008. 10.5 is 2008 R2.Tibor Karaszi, SQL Server MVP | web | blog Proposed as answer by PrinceLucifer Thursday, March 01, 2012 5:48 PM Marked as answer by Brijesh Shah Friday, March 02, 2012 4:58 AM Thursday, March 01, 2012 12:32 PM Reply | Quote Moderator All replies 0 Sign in to vote You are trying to restore a backup from SQL Server 2008 R2 to SQL Server 2008. No can do. Y
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 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 https://social.msdn.microsoft.com/Forums/sqlserver/en-US/45f74673-80cf-48b3-b062-7e0878d63848/sql-server-backup-restore-error-that-version-is-incompatible-with-this-server?forum=sqldisasterrecovery 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 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 http://stackoverflow.com/questions/15788624/restore-a-sql-server-2000-backup-on-sql-server-2012 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 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, won
ASP.NET Community Standup Forums Help Home/ASP.NET Forums/Data Access/SQL Server, SQL Server Express, and SQL Compact Edition/Expert Help Please...incompatibility issue with MS SQL 2008 or 2012 Expert Help Please...incompatibility issue with MS SQL http://forums.asp.net/t/2060816.aspx?Expert+Help+Please+incompatibility+issue+with+MS+SQL+2008+or+2012 2008 or 2012 [Answered]RSS 2 replies Last post Jul 27, 2015 10:30 AM by PatriceSc ‹ Previous Thread|Next Thread › Print Share Twitter Facebook Email Shortcuts Active Threads Unanswered Threads Unresolved Threads Support Options Advanced Search Reply slimbunny Member 703 Points 1260 Posts Expert Help Please...incompatibility issue with MS SQL 2008 or 2012 Jul 27, 2015 10:12 AM|slimbunny|LINK Can anyone help me resolve this incompatibility issue with sql server MS SQL 2008 or2012 - When I try to restore a database I get this message? -------- Error Message: Restore failed for server ....\SQLExpress An exception occurred while executing a Transaction-SQL Statement or Batch The database was backed up on a server running version 10.50.2550. That version is incompatible with this server, which is running version 10.00.2531. Either restore the database on a server that supports the error 3169 sql backups, or use a backup that is compatible with this server. RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3169) A Lifetime ASP.NET DEVELOPER Reply limno All-Star 121380 Points 9389 Posts Moderator Re: Expert Help Please...incompatibility issue with MS SQL 2008 or 2012 Jul 27, 2015 10:30 AM|limno|LINK 10.50.2550. SQL Server 2008 R2 SP1 10.50.2531. SQL Server 2008 SP1 You cannot restore a backup created from higher version to a lower version. You need to upgrade your SQL Server to a higher version to be able to restore this backup. Jingyang Li Format your SQL query with instant sql formatter: http://www.dpriver.com/pp/sqlformat.htm Reply PatriceSc All-Star 32390 Points 9255 Posts Re: Expert Help Please...incompatibility issue with MS SQL 2008 or 2012 Jul 27, 2015 10:30 AM|PatriceSc|LINK Hi, According to https://www.rocksolidsql.com/RealWorldData/SQLServer/SQLServerVersion.aspx?SQLServerVersionKey=17ac683b-2abd-4a45-9ca5-6da2272d7236you are trying to restore a SQL Server 2008 R2 database to SQL Server 2008. You can restore a db tothe same or a later versionbut not toan earlier version. Double check you are using the version you expect. If you really need to copy to an earlier version you'll likely have to use the "copy wizard": https://msdn.microsoft.com/en-us/library/ms189624.aspx ‹ Previous Thread|Next Thread › This site is managed for Microsoft by Neude