Trying to restore database in Enterprise Manager and I get error
Posted on 2004-10-19
I am attempting to restore f:\sqldata\mydatabasebackup to my mydatabase.mdf file in Enterprise Manager and I get this error "Exclusive access could not be obtained because the database is in use. Restore database is terminating abnormally."
I tried to take it offline and it failed with an error 5070.
What do I need to do to get exclusive use and to get this restore done.
I tried to clear connections when I Detached the database but when I reattached it the connection was back.
Thanks for any help.