{"id":196,"date":"2012-05-10T07:59:42","date_gmt":"2012-05-10T07:59:42","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2012\/05\/10\/fix-cannot-restore-sql-server-2000-backup-on-sql-server-2012\/"},"modified":"2012-05-10T07:59:42","modified_gmt":"2012-05-10T07:59:42","slug":"fix-cannot-restore-sql-server-2000-backup-on-sql-server-2012","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2012\/05\/10\/fix-cannot-restore-sql-server-2000-backup-on-sql-server-2012\/","title":{"rendered":"FIX &#8211; Cannot Restore SQL Server 2000 Backup on SQL Server 2012"},"content":{"rendered":"<p><strong>Unable to Restore SQL Server 2000 Backup on SQL Server 2012?<\/strong><\/p>\n<p>If you are trying to restore SQL Server 2000 backup on SQL Server 2008 you would be facing error like:<\/p>\n<p><font color=\"red\"><br \/>\nMsg 3169, Level 16, State 1, Line 1<\/p>\n<p>The database was backed up on a server running version 8.00.2055. That version is incompatible with this server, which is running version 11.00.2100. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.<br \/>\n<\/font><\/p>\n<p>Restoring SQL Server 2000 backup to SQL Server 2012 is not supported.<\/p>\n<p><strong>Why?<\/strong><br \/>\nAccording to <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms186858.aspx\" target=\"_blank\" rel=\"noopener noreferrer\">MSDN<\/a> <em>In SQL Server 2012, you can restore a user database from a database backup that was created by using SQL Server 2005 or a later version.<\/em><\/p>\n<p><strong>How to restore then?<\/strong><br \/>\n<strong>Fix\/resolution:<\/strong><br \/>\n<em>Use SQL Server 2008 R2 as an intermediate source.<\/em><\/p>\n<p><strong>Steps:<\/strong><br \/>\n1. First restore the SQL Server 2000 backup to SQL Server 2008 r2.<br \/>\n2. Then backup the database from  SQL Server 2008 r2 and restore it on SQL Server 2012.<\/p>\n<p>If you do not have SQL Server 2008 r2, You can download a trial version of SQL Server 2008 r2 from the below links.<br \/>\n <a href=\"http:\/\/msdn.microsoft.com\/en-us\/evalcenter\/ff459612\" target=\"_blank\" rel=\"noopener noreferrer\">http:\/\/msdn.microsoft.com\/en-us\/evalcenter\/ff459612<\/a><br \/>\n <a href=\"http:\/\/www.microsoft.com\/sqlserver\/en\/us\/editions\/previous-versions.aspx\" target=\"_blank\" rel=\"noopener noreferrer\">http:\/\/www.microsoft.com\/sqlserver\/en\/us\/editions\/previous-versions.aspx<\/a><\/p>\n<p>Alternatively you can use SQL Server 2005 (or) SQL Server 2008   also as an intermediate source.<\/p>\n<p>Following the above steps should help solve the problem.<\/p>\n<p>Also verify the database backup on each target server before restoring:  <a href=\"http:\/\/sqlserverlearner.com\/2012\/verify-sql-server-database-backup\" target=\"_blank\" rel=\"noopener noreferrer\">Verify SQL Server Database Backup<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Unable to Restore SQL Server 2000 Backup on SQL Server 2012? If you are trying to restore SQL Server 2000 backup on SQL Server 2008 you would be facing error like: Msg 3169, Level 16, State 1, Line 1 The database was backed up on a server running version 8.00.2055. That version is incompatible with&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[128,1922,1923,1924,3],"tags":[],"class_list":["post-196","post","type-post","status-publish","format-standard","hentry","category-sql-errors","category-sql-server-2000","category-sql-server-2008-r2","category-sql-server-2012","category-sqlserverpedia-syndication"],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/196","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=196"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/196\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=196"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}