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. Read more great feeds at is source WEBSITE
no comments.
Read more articles on Restore and Express and otherSoftware and SQL.
- [+] Digg: Feature this article
- [+] Del.icio.us: Bookmark this article
- [+] Furl: Bookmark this article
