Restore Backup From SQLSERVER 2000 To SQLSERVER 2012 Fails

Today I have been requested to move an old database Sqlserver 2000 to a Sqlserver 2012. When I executed the restore I got the next error;

TITLE: Microsoft SQL Server Management Studio

Restore of database ‘HERCULES40’ failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)


System.Data.SqlClient.SqlError: The database was backed up on a server running version 8.00.0760. 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. (Microsoft.SqlServer.SmoExtended)

For help, click:

In this case I forgot to check the compatible matrix for backp and restores between version, of course, is my fault. Okay possible solutions;

i) Upgrade fro 2000 to 2012, through the versions like 2008.

ii) Jump, restore this backup in a 2008 and generate a new backup and restore it in 2012.

In my case, option ii was choosed.



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s