Monday, April 16, 2012

Restore failed for Server ''

TITLE: Microsoft SQL Server Management Studio
------------------------------

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

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.5500.0+((Katmai_PCU_Main).110921-2358+)&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 10.50.2500. That version is incompatible with this server, which is running version 10.00.5500. 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.0.5500.0+((Katmai_PCU_Main).110921-2358+)&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------
Solution : check this.



This is an error sometimes you get when restoring a DB which backup-ed from  a server which  has newer sql server version than what you have so in this case to restore this you need to install sql server newer version or upgrade the existing.
References:


http://sqlgain.blogspot.com/2011/12/sql-server-versions.html

No comments:

Post a Comment