hello!
When I run a TSQL command to restore database, I got this
error:
"Restore database is terminating abnormally.
Exclusive access could not be obtained because the
database is in use".

My command for restoring is
'restore database aasam from aasam_backup'
I tried using the command below, but still doesn't work.
'alter database edtsam set single_user with rollback
immediate'.

Any advice? Pls help.

Rgds,
Sam.

Make sure "YOU" are not the one in the DB.

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Sam" <samuel.soong (AT) sgprivasia (DOT) com> wrote

The following set of commands should work... We run
something similar to this...

ALTER DATABASE aasam SET single_user WITH ROLLBACK
immediate

RESTORE DATABASE aasam FROM DISK = 'C:\\aasam_backup'
WITH REPLACE

ALTER DATABASE aasam SET MULTI_USER


HTH.
Cheers,
Sanka