Error 3169 Restore
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
Restore Sql 2000 Database To Sql 2012
unique situations and then resolve them too. And this is more of a diary of sql server version numbers the error messages I am getting into. I was playing with my Demo database on SQL Server 2016. Once done, I started restoring sql server 2014 from the 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
Msdn
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 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 exac
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, 2011 3:34 AM 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/ 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 running version 10.50.1600. That version http://www.sqlservercentral.com/Forums/Topic1133525-1550-1.aspx 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 from your enterprise server and run these against the express
SonicWALL User Sorry, we are having issues processing your request. If you own the SonicWALL product requested please confirm that you have https://support.software.dell.com/litespeed-for-sql-server/kb/40614 registered your product at My SonicWALL . If you have 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 the inconvenience. Continue Search sql server 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 Management Database Replication & Backup Endpoint error 3169 restore 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 For more information regarding support on your Dell Software Product, please visit www.software.d