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
 Other SQL Server Topics (2005)
 Help in sql 2005 error

Author  Topic 

fypj2010
Starting Member

2 Posts

Posted - 2010-07-22 : 22:23:15
i've encountered this error while trying to restore a database back up file.
the error goes
"the backup set holds a backup of a database other than the existing "..." datebase. Restore database is terminating adnormally (ERROR:3145)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-07-22 : 22:27:37
Try adding WITH REPLACE to the RESTORE DATABASE command.

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

Subscribe to my blog
Go to Top of Page

fypj2010
Starting Member

2 Posts

Posted - 2010-07-22 : 22:49:20
Sorry mate, i'm new to this sql thing. Do you mind teaching me the replace method? appreciated!
Go to Top of Page

fayalif
Starting Member

8 Posts

Posted - 2010-07-26 : 07:48:53
Hope this will help you out.

http://blog.sqlauthority.com/2007/09/27/sql-server-fix-error-3154-the-backup-set-holds-a-backup-of-a-database-other-than-the-existing-database/

Regards,
fayalif
Go to Top of Page
   

- Advertisement -