Your best source of information and news about microsoft, software and windows vista on the internet

Vista ARTICLES TOP 50 Spyware Virus Vista SOFT Vista HELP

Restore

You are currently browsing the articles from MS Windows Vista Compatible Software matching the category Restore.

Restore failed for Server ‘SERVER\SQLEXPRESS’. (Microsoft.SqlServer.Express.Smo)

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

Restore failed for Server 'SERVER\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'DEVELOP' database. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476

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

OK
------------------------------


I had the above message when I tried to restore a backup.
The solution is simple.

In the options pane, just select overwrite the existing database thats it.

Written by Teus on May 14th, 2008 with no comments.
Read more articles on Restore and Express and otherSoftware and SQL.