Error 3169 The Backed-up
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 am able to get into unique restore sql 2000 database to sql 2012 situations and then resolve them too. And this is more of a diary of the error sql server version numbers messages I am getting into. I was playing with my Demo database on SQL Server 2016. Once done, I started restoring from the sql server 2014 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 13.00.0801. That version is incompatible with this server, which is running version
Msdn
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 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 to create the complete database schema without data.Move the dataTo move the data, you have a couple of options, but all of these are a bit tricky.Script out the data exactly the way described in the above
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) 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 Disaster Recovery Question 0 Sign in to vote Hi Team, I am having one issue ... 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. I have created blank database and try to restored that.. but it gives me an error like The Database was backed up 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/ 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 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 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. 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
additional information might be available elsewhere. Thank you for searching on this message; your search helps us identify those error 3169 the areas for which we need to provide more information. If the product or version you are looking for is not listed, you can use this search box to search TechNet, the Microsoft Knowledge Base, and TechNet Blogs for more information. Enter the product name, event source, and event ID. For example: Vista Application Error 1001.
and shrinking the transaction log Backing up the tail Inside the transaction log So, what's in a backup file? Test: A full backup does not contain deleted data Verifying backup files Verifying backup files on a budget Cumulative backups Recovering individual tables Backup and restore history details Backup reads and writes Speeding up backups Backup speed details Speeding up restores Restore state affects speed too Backup and restore rights Log shipping Log shipping in SQL Server 2000 Setting up log shipping using Enterprise Manager Checking the set up Failover Log shipping in SQL Server 2005 Setting up log shipping using Management Studio Checking the set up Log shipping status report Failover Log shipping in SQL Backup Using the CopyTool utility Failover 3rd party backup applications VDI VDI versions VDI errors SQL Backup - beyond compression Restoring a chain of transaction log backups Restoring to the latest possible state Backing up multiple databases Backup retention Making a copy of the backup file Backup file naming conventions Restoring the latest backup set Network resilience Encryption Integrated database verification Database file relocation Improved backup retention RESTORE HELP High-availability group support Common SQL Backup issues Installation checklist Setting up rights Configuring service rights Backup data Hanging issues Common backup and restore errors Error 3201 - when performing a backup to a network share Full database backup file is larger than database size Error 3205 - Too many backup devices specified for backup or restore Error 4305 - an earlier transaction log backup is required Bringing a database that is in recovery or read-only mode online Using bulk-logged recovery model but transaction log backup is still large Error 14274 - unable to delete SQL Server Agent job Error messages when restoring from different versions of SQL Server. Pending vdi error codes Restore speed details Help, my transaction log file is huge! Mirror or log ship You cannot restore a backup created with a newer version of SQL Server on an instance running an older version of SQL Server. Unfortunately, the error messages that are displayed may not always tell you that it is a versioning problem. These are some of the error messages raised when trying to restore a backup file that is not backwards compatible. SQL Server 2008 R2 to SQL Server 2008 Msg 3169, Level 16, State 1, Line 1 The database was backed up on a server running version 10.50.1600. That version is incompatible wit