skip to main
|
skip to sidebar
Web Tips & Tricks
Wednesday, September 9, 2009
Solution to: The backup set holds a backup of a database other than the existing database
SQL Error:
Error 3154: The backup set holds a backup of a database other than the existing database.
Here is the solution:
RESTORE DATABASE <dbname>
FROM DISK =
'<dbname.bak file path on local machine>' /*e.g. 'c:\dbname.bak' */
WITH
REPLACE
Newer Posts
Older Posts
Home
Subscribe to:
Comments (Atom)
Blog Archive
▼
2009
(25)
▼
September
(1)
Solution to: The backup set holds a backup of a da...
►
August
(24)
About Me
Web Tips & Tricks
View my complete profile
Followers