I am getting following message when trying to restore a newly created database with existed backup file file. I am getting the follow in messages
RESTORE DATABASE TestDB
FROM DISK = '\\xyz\Databackups\ddd.BAK'
WITH MOVE 'ddd_Data' TO 'E:\Microsoft SQL Server\MSSQL\data\TestDB_Data.MDF',
MOVE 'ddd_Log' TO 'E:\Microsoft SQL Server\MSSQL\data\TestDB_Log.LDF'
Server: Msg 3101, Level 16, State 2, Line 1
Exclusive access could not be obtained because the database is in use.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Thanks in Advance