SQLTeam.com | Weblogs | Forums

Restore mssql server backup 2000 in 2008


#1

I need to restore my mssql server DB backup which in 2000 into mssql server 2008 but it is failing with below error
TITLE: Microsoft SQL Server Management Studio

Restore failed for Server 'BDDHKPS01'. (Microsoft.SqlServer.SmoExtended)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0026+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476


ADDITIONAL INFORMATION:

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

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0026+)&LinkId=20476


BUTTONS:

OK


#2

You are using SQL 2012, not SQL 2008. Version 11 is SQL 2012.

You cannot restore a SQL 2000 database to a SQL 2012 server. You will need to do an intermediate step such as restoring it to a SQL 2008 server and then from there to SQL 2012. See this article.