Tuesday, November 20, 2012

SQL SERVER with Error restore database the backup set holds a backup of a database other than the existing


Do not think that your days will destroy when you see this error
Use the command below should solve your problem like me...
The explanation is use REPLACE other than RESTORE

RESTORE DATABASE ENABLERDB
FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\myDB.bak'
WITH REPLACE

No comments: