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 2000 Forums
 SQL Server Administration (2000)
 Backup and restore

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-06-30 : 07:20:39
Shantanu writes "I am trying to restore a Database that is carban copy of orginal database from Backup file that was taken for original database
but getting the failure with following message.

Backup set holds a backup of a database other than the existing database"

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-06-30 : 08:43:38
You need to use the WITH MOVE option on your RESTORE.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -