error while recovering a DB - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

error while recovering a DB

Author

Topic

st st
Starting Member

2 Posts

Posted - 2011-05-27 : 12:51:42

hello,
can someone help me with this error?
I am trying to restore a database from a .bak file
Thank you in advance.

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

Restore failed for Server 'STOYAN'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.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 'D' database. (Microsoft.SqlServer.Smo)

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

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-05-27 : 12:57:21

Go to the options page in the RESTORE GUI, select the option to replace and also move your files to a proper path and non-used names.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog