Microsoft Sql Server 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
Restore Sql 2000 Database To Sql 2012
is incompatible with this server SQL Server > SQL Server High the database was backed up on a server running version 8 Availability and Disaster Recovery Question 0 Sign in to vote Hi Team, I am having one issue ...
Sql Server Version Numbers
Actually One of my server 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 server 2014 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 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 msdn 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
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 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 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 incompatible with this server, which is running version 11.00.3128. Either restore the database on a server that supports the http://stackoverflow.com/questions/15788624/restore-a-sql-server-2000-backup-on-sql-server-2012 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, 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) –T
SonicWALL User Sorry, we are having issues processing your request. If you own the SonicWALL product requested please confirm that https://support.software.dell.com/litespeed-for-sql-server/kb/40614 you have registered your product at My SonicWALL . If you have https://forums.asp.net/t/2060816.aspx?Expert+Help+Please+incompatibility+issue+with+MS+SQL+2008+or+2012 already registered your product then please contact Customer Service directly for further assistance at customerservice@software.dell.com. Continue × Support Forms Under Maintenance Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for sql server the inconvenience. Continue Search Sign In Sign In Create Support Account Products ActiveRoles Boomi Change Auditor Foglight Identity Manager KACE Migration Manager Rapid Recovery Recovery Manager SharePlex SonicWALL Spotlight Statistica Toad View all Products Solutions Application & Data Integration Big Data Analytics Business Intelligence Cloud Management Data Protection Overview Backup and Recovery Deduplication and Compression Database Development and microsoft sql server Management Database Replication & Backup Endpoint Management Mobile Workforce Management Overview Desktop Virtualization Enterprise Mobility Management Endpoint Security Network Security Secure Remote Access Performance Monitoring Security Overview Email Security Endpoint Security Identity & Access Management Network Security Secure Remote Access Virtualization Management Microsoft Platform Management View all Solutions Solutions by Platform Active Directory Exchange Google GroupWise & NDS Hadoop Hyper-V Lotus Notes Skype for Business/Lync Office 365 Oracle SharePoint SQL Server VMware Trials Buy Support By Product Line Enterprise Reporter Foglight KACE Migration Manager Migrator NetVault One Identity Quick Connect Performance Analysis Recovery Manager Shareplex SonicWALL Spotlight SQL Navigator Toad All Products Contact Support Download Software Knowledge Base My Account My Products My Service Requests My Licenses My Groups My Profile Policies & Procedures Professional Services Technical Documentation Training & Certification User Forums Video Tutorials Support Home Communities Partners × Email Share your favorite Support content with a friend. Email To Email From Subject Information from Dell Software Support Message You might be interested in the following information F
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 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 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 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 121420 Points 9397 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 32610 Points 9300 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=17ac