The backup set holds a backup other than the existing database SQL Server

311
Views
1
Answers

I am trying to restore the database with SQL Server restore option. I get this error during the restore process.
alt text

The backup set holds a backup other than the existing database

edit | flag
Mike Carpenter
Asked on: Feb 04, 2012 at 6:29AM

1 Answers

121
3
121

Here is the work around. Try this Sql script which has REPLACE function

RESTORE DATABASE AdventureWorks
FROM DISK
= 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\DBBackup.bak'
WITH REPLACE
edit | flag
Gokul A
Answered on: Feb 04, 2012 at 6:34AM

Post your Answer

Search

Welcome to Ask Amoeba!
This is 100% free and interactive site for sharing professional Questions and Answers, Opensource projects, Interview questions.
Learners, beginners, Experts stop and share your knowledge and ideas!

Browse Categories

Browse Tags