Microsoft Sql Server 2008 Error 3169
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 this server SQL Server > SQL Server High Availability and restore sql 2000 database to sql 2012 Disaster Recovery Question 0 Sign in to vote Hi Team, I am having one
The Database Was Backed Up On A Server Running Version 8
issue ... Actually One of my server having Database SQL Server which has around 5 GB of Backup file (One Database) now,
Sql Server Version Numbers
I need to restore that on another Server of SQL. I have created blank database and try to restored that.. but it gives me an error like The Database was backed up on a server running
Sql Server 2014
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 msdn 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. You can't restore a backup from a newer version of SQL Serveronto an older version.Tibor Karaszi, SQL Server MVP | web | blog Proposed as answer by PrinceLucifer Thursday, March 01, 2012 5:48 PM Thursday, March 01, 2012 12:00 PM Reply | Quote Moderator 0 Sign in to vote Hi Tibork, Actually My Version (Where i am restoring the Database) is1
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2008 » SQL Server 2008 Administration » How to Restore the backup file from Sql... 15 posts,Page 1 of 212»» How to Restore the backup file from Sql server 2008 enterprise to SQL server 2008 express edition . Rate Topic Display Mode Topic Options Author Message dm_tapasdm_tapas Posted Wednesday, June 29, 2011 3:34 AM Ten Centuries Group: General Forum Members Last Login: Thursday, February 12, 2015 10:50 AM Points: 1,026, Visits: 423 How Can I Restore the backup file from Sql 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 server 2008 enterprise to SQL server 2008 express edition : In general restoration process , I got the following error:The database was backed up on a 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 is compatible with this server.RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3169)----somebody http://www.sqlservercentral.com/Forums/Topic1133525-1550-1.aspx suggest the good idea to do that. Post #1133525 steveb. steveb. Posted Wednesday, June 29, 2011 3:38 AM SSCrazy Group: General Forum Members Last Login: Monday, August 24, 2015 6:12 PM Points: 2,808, Visits: 7,195 you can't sorry,one option would be use ssis to copy the data across. Post #1133528 dm_tapasdm_tapas Posted Wednesday, June 29, 2011 3:42 AM Ten Centuries Group: General Forum Members Last Login: Thursday, February 12, 2015 10:50 AM Points: 1,026, Visits: 423 Any other option .. Like, Using SSMS.. or T-Sql Post #1133532 steveb. steveb. Posted Wednesday, June 29, 2011 3:46 AM SSCrazy Group: General Forum Members Last Login: Monday, August 24, 2015 6:12 PM Points: 2,808, Visits: 7,195 well you could use SSMS to generate the T-SQL scripts from your enterprise server and run these against the express server, also in 2008 you get the option of scripting the data.Though the point is that they are different versions of sql server and enterprise has many features not in express so this is why the restore option wont work and the scripts may or may not run depending on how many enterprise only features you are using Post #1133534 dm_tapasdm_tapas Posted Wednesday, June 29, 2011 3:49 AM Ten Centuries Group: General Forum Members Last Login: Thursday, February 1
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 http://stackoverflow.com/questions/15788624/restore-a-sql-server-2000-backup-on-sql-server-2012 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 https://support.software.dell.com/litespeed-for-sql-server/kb/40614 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 sql server 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 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 microsoft sql server 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 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