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)

——————————
ADDITIONAL INFORMATION:

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: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.2100.60+((SQL11_RTM).120210-1917+)&LinkId=20476

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.

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s