Error 3169 The Backed Up Database
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 restore sql 2000 database to sql 2012 glad that I am able to get into unique situations and then resolve them sql server version numbers too. And this is more of a diary of the error messages I am getting into. I was playing with sql server 2014 my Demo database on SQL 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 msdn up on a server running version 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 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
up 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, 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/ 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 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 http://www.sqlservercentral.com/Forums/Topic1133525-1550-1.aspx 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 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 fro
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Restoring SQL Server 2005 backup to SQL server 2000 SQL Server > SQL Server Database https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4c263da0-21f3-4434-8f10-6804a7c0a5bc/restoring-sql-server-2005-backup-to-sql-server-2000?forum=sqldatabaseengine Engine Question 0 Sign in to vote I have a sql 2005 backup that I am trying to restore in sql 2000. I get the following error.. Error:3169 The backed up database http://solutioncenter.apexsql.com/restore-sql-server-database-backup-to-older-version-of-sql-server/ has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database. Restore filelist is terminating abnormally. Is there a workaround for this? Vyanki Friday, June 09, sql server 2006 10:22 AM Reply | Quote Answers 0 Sign in to vote No, there is no workaround. SQL Server 2005 does not support downgrades or restores to SQL Server 2000. Friday, June 09, 2006 2:53 PM Reply | Quote All replies 0 Sign in to vote No, there is no workaround. SQL Server 2005 does not support downgrades or restores to SQL Server 2000. Friday, June 09, 2006 error 3169 the 2:53 PM Reply | Quote 0 Sign in to vote thanks. what way can be come true the case. Friday, September 15, 2006 10:10 AM Reply | Quote 0 Sign in to vote There is no "Restore" functionality, but there is a workaround to copy 2005 databases to 2000:Right-click on DB -> tasks -> generate scriptsselect DB and click "script all objects...", hit nextselect any options you want, specifically changing "script for server version" to SQL Server 2000next through and run the scriptNow just export data from the 2005 database to the newly-created 2000 database.Right-click on DB -> tasks -> export...set source and hit nextset destination and hit nextselect "copy data from one or more tables", hit nextselect all, check "optimize for many tables" and "run in a transaction"you may have to edit each table mapping and check "enable identity insert"next through to finish Friday, September 15, 2006 1:58 PM Reply | Quote 0 Sign in to vote Jonathan Fife wrote:There is no "Restore" functionality, but there is a workaround to copy 2005 databases to 2000:Right-click on DB -> tasks -> generate scriptsselect DB and click "script all objects...", hit nextselect any options you want, specifi
DiffApexSQL DiffApexSQL DocApexSQL GenerateApexSQL RefactorApexSQL ScriptApexSQL SearchApexSQL Source ControlApexSQL TriggerApexSQL Unit Test What's new What's nextDatabase administrationPerformance monitoringTransaction log readingBackup and restoreAuditingDisaster recoveryIndex defragmentationDatabase developmentChange managementAnalysis and documentationScripting and deploymentDatabase comparisonSQL source controlDeveloper productivityTest data generationCustom application auditingUnit testingVisual Studio add-insSSMS add-insFree SQL toolsSQL Azure tools Solution center Solution center How to restore a SQL Server database backup to an older version of SQL Server If there was need to restore a SQL Server database backup to an older version of SQL Server there was "greeting" with error messages along the lines of:Msg 3169, Level 16, State 1, Line 1 Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally.orMsg 3241, Level 16, State 7, Line 1 Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally.and the attempted backup restore would fail. The reason for this behavior is that by default SQL Server doesn't allow restoring a database backup to an older version of SQL Server, regardless of the compatibility level of the database the backup was taken from.However, there is a way to restore a database to a newer SQL Server version.If there is access to the live database backup was taken from:Start SQL Server Management Studio and connect to the instance where the database residesIn the database context menu, navigate to Tasks | Generate Scripts…. This will invoke the Generate and Publish Scripts wizardIn the Introduction step of the wizard click NextIn the Choose Objects step of the wizard make sure that the Script entire database and all database objects option is selected and click NextIn the Set Scripting options step of the wizard:Select the Save scripts to a specific location optionSpecify whether the database objects and data will be scripted to a single file, multiple files, as well as the path and encoding of the generated scriptsClick AdvancedIn the Advanced Scripting Options dialog that will appear:Specify the version of the SQL Server you need the database restored to in the Script for Server Version optionIn the Script for Server Version option, specify Schema and dataSet the following options to True:Script LoginsScript Full-Text IndexesScript TriggersClick OKClick NextIn the Summary step of the wizard, click NextIn the Save or Publish Scripts step of the wiza