469,076 Members | 1,364 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,076 developers. It's quick & easy.

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!
May 9 '07 #1
5 904
NiteshR
21
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.table

thanks.
May 10 '07 #2
Sorry, but I'm not following how this will fix my problem.
May 10 '07 #3
Anyone?.... Anyone? Bueller?...Bueller??
May 10 '07 #4
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.
May 10 '07 #5
imtmub
112 100+
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
May 11 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Tim Morrison | last post: by
3 posts views Thread by Jon Jacobs | last post: by
1 post views Thread by Raquel | last post: by
4 posts views Thread by Hardy | last post: by
9 posts views Thread by GL | last post: by
13 posts views Thread by Andy K | last post: by
5 posts views Thread by chow.justy | last post: by
1 post views Thread by nikb | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.