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 2008 Forums
 Other SQL Server 2008 Topics
 Restoring an sql 2005 database in sql 2008

Author  Topic 

funkyspirit
Starting Member

9 Posts

Posted - 2012-05-05 : 03:33:50
Hello,

I have a backup of an sql 2005 server database that I am trying to restore to an sql server 2008 r2.

The backup is a full backup. However, when I try to run the restore, I get an error message saying "the backup set holds a backup other than the existing database". The database is the same however.

Does anyone know what the issue is and what can be done for it to work?

Thank you.

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-05-05 : 05:26:06
Could you post the RESTORE procedure?
Check this post for a solution using WITH REPLACE for the 3154 error
http://www.sqlserver-dba.com/2008/12/sql-server-restore-problem---error-3154-the-backup-set-holds-a-backup-of-a-database-other-than-the-existing-database.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -