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
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!