Backup Set Holds A Backup Of A Database Other Than The Existing

If you are getting Error 3154 or The Backup Set Holds A Backup Of A Database Other Than The Existing Database Error while restoring backup of sql server from one system to another,

Than you need use following command to get rid of this error and restore the Sql server database

RESTORE DATABASE DataBaseName
FROM DISK = 'C:\BackupFileName.bak'
WITH REPLACE


This will hopefully fix the error and restore the database


Related Posts:
Finding IP address behind Proxy using C# in ASP.NET
Export GridView to Pdf using iTextSharp in asp.net
Hide GridView columns in normal mode and visible in edit mode
Change Mode of DetailsView or FormView when Default Mode is Set to Insert in ASP.NET

Other SQL Server articles:
1.Import/Export Excel Data into Sql Server using SqlBulkCopy-ASP.NET
2.Install configure and troubleshooting sql server reporting services 2005
3.Ms sql server bulk insert method to import bulk csv data into database
4.Combine Multiple Records Comma Separated In One Column MSSQL
If you like this post than join us or share

5 comments:

Anonymous said...

ytgr fehkr er we


Anonymous said...

Thanks a lot this worked


Anonymous said...

It works; but not for this scenario

Backup from SS 2003 with database files locate in driver D:
Restore into SS 2008, the machine has only driver C:

For solving this:

1) I create new DB with database files located in driver d:
2) Get the backup from SS 2003
3) Restore in SS 2008 using WITH REPLACE


Anonymous said...

i used fix error "The backup set holds a backup of a database other than the existing database-Sql Server Error 3154" by using command:
RESTORE DATABASE Tea2011
FROM DISK = 'D:\Software_deploy\Database\ACS2011'
WITH MOVE 'ACS2011_Data' TO 'D:\Software_deploy\Database\Tea2011.mdf',
MOVE 'ACS2011_Log' TO 'D:\Software_deploy\Database\Tea2011.ldf',
REPLACE
with ACS2011: backup file
Tea2011.mdf and Tea2011.ldf: database need restore
ACS2011_Data And ACS2011_Log: Database backuped to file ACS2011


Sudhanshu Sahoo said...

helped me, thanks


Find More Articles