Problem

When trying to restore a backup taken on SQL Server 2000 on a SQL Server 2012 the following error appears:

  

 Msg 3169, Level 16, State 1, Line 2

The database was backed up on a server running version 8.00.0818. That version is incompatible with this server, which is running version 11.00.3000. 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 2

RESTORE DATABASE is terminating abnormally.

 

The problem is that on a SQL Server 2012 instance you cannot restore a SQL Server 2000 backup. Practically on SQL Server 2012 you can restore backups taken on SQL Server 2005 or later.

  

Solution

This situation can be avoided by performing the following steps:

  1. Restoring the SQL Server 2000 backup on SQL Server 2005 or 2008
  2. Set compatibility level to 90 (SQL Server 2005) or 100 (SQL Server 2008 / SQL Server 2008 R2)
  3. Backup the same database and restore it on the SQL Server 2012.

  

  


2 comments

Comment from: Android Training in Chennai [Visitor]
Android Training in ChennaiHi this is Kathiresan i am having 3 years of experience as a dot net developer and i am certified. i have knowledge on OOPS concepts in .NET but dont know indepth. After learning android will be enough to get a good career in IT with good package? and i crossed http://www.besanttechnologies.com/training-courses/android-training-institute-in-chennai website where someone please help me to identity the syllabus covers everything or not??

Thanks,
kathiresan
02/13/15 @ 10:48
Comment from: Yashika [Visitor]
YashikaI'm very glad when read your article. It's easy to understand and very useful for newbie as me. Thank you so much and wish you happy…http://www.aimitacademy.com/android-training-in-chennai/
05/17/16 @ 16:29

This post has 1 feedback awaiting moderation...

Leave a comment


Your email address will not be revealed on this site.
(Line breaks become <br />)
(For my next comment on this site)
(Allow users to contact me through a message form -- Your email will not be revealed!)