I found this error message when i restore the database using the GUI and it appear this error message "Error 3154: The backup set holds a backup of a database other than the existing database"
It because of trying to restore database on an existing active database.
Solution:
RESTORE DATABASE DatabaseName
FROM DISK = 'C:\myDatabase.bak'
WITH REPLACE
Use WITH REPLACE when using RESTORE command when u saw above error message "Error 3154: The backup set holds a backup of a database other than the existing database"
Tested in MSSQL 2005
Wednesday, June 16, 2010
RESTORE DATABASE using command
Posted by Emil Chang at 8:36 AM
Subscribe to:
Post Comments (Atom)
1 comments:
The site SQL Reports has a great SQL tutorial. Highly recommended for people just getting started on SQL selects.
http://www.sql-reports.net/
http://www.sql-reports.net/2011/03/sql-select-tutorials.html
Post a Comment