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
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
Backup Set Holds A Backup Of A Database Other Than The Existing
Posted by
Unknown
RESTORE DATABASE DataBaseName
If you like this post than join us or share
Labels: Sql Server
Subscribe to:
Post Comments (Atom)
5 comments:
ytgr fehkr er we
Thanks a lot this worked
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
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
helped me, thanks
Post a Comment