DB restore question

[Jen Eric]

I'm backing up my db via Query Analyzer but I get an error when trying to restore saying that Admin needs to have "exclusive" use of the db or that the db is in use. Is there an exclusive parameter that needs to be included in my statement and if so, where?
Thanks!

[NiteshR]

I'm backing up my db via Query Analyzer but I get an error when trying to restore saying that Admin needs to have "exclusive" use of the db or that the db is in use. Is there an exclusive parameter that needs to be included in my statement and if so, where?
Thanks!

Hi, try 1 of 2 things,

1.
On the enterprise manager, make sure you are added as one of the users for that specific db.


2.
If you are not the creator/owner of the
eg.

SELECT *
FROM owner_name.tabl e

thanks.

[Jen Eric]

Sorry, but I'm not following how this will fix my problem.

[Jen Eric]

Anyone?.... Anyone? Bueller?...Buel ler??

[Jen Eric]

I was able to get the restore to run in query analyzer by changing the drop down db to master where before I had the db I was trying to restore to selected. I hope this is okay and that I havent' just created a monster.

[imtmub]

I was able to get the restore to run in query analyzer by changing the drop down db to master where before I had the db I was trying to restore to selected. I hope this is okay and that I havent' just created a monster.

Hi,
try using red gate sql back5.0 application to backup then restore. This application u can download full version 14 days trial. This is really good.

Mohammed