472,365 Members | 1,644 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,365 software developers and data experts.

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 1035
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

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

Similar topics

3
by: Tim Morrison | last post by:
MSDE2000 I have an application in which I am running a TSQL command of BACKUP DATABASE and RESTORE DATABASE for the backup and restore commands for my application. For testing purposes, i did the...
3
by: Jon Jacobs | last post by:
I attempt to back up a database on one server and restore it on my local machine. This is what the query text looks like: restore database model from Disk='c:\JQJ\mydump\model.bak' with...
1
by: Raquel | last post by:
Had a simple question..there is a command in UDB: RESTORE DB a TAKEN AT ts1 INTO b Where 'a' is one database, 'b' is another database and ts1 is a timestamp in the past when database 'a' was...
3
by: Vikrant | last post by:
Friends, Due an application (old) install program problem, Under AIX I could only create DB2 instance, I could also catalog it. Its complex application and I am not expert in creating full...
4
by: Hardy | last post by:
hi gurus, now I have to backup and restore a 8 T size db2 database. from two s85 to two 670. the partitions,tablespaces of the db should be redesigned then I plan to use redirected restore. but...
9
by: GL | last post by:
I am running DB2 8.1.1 on AIX 5.1 Having a problem with a redirected restore. Once into the restore continue phase, I immediately get the following SQL2059W A device full warning was...
13
by: Andy K | last post by:
Hi , I'm wondering what's going on with a restore I'm trying to do . My DB2 version is a 7.2 on a Linux RH ES 2.1 . I've copy a recent backup that was on NAS for a test on my machine . I...
6
by: Raj | last post by:
How can we do an online restore of a tablespace using the incremental backup's? we are on a partitioned database... Also, how could we use backup copy made by the load (using the copy to option...
5
by: chow.justy | last post by:
Dear all, I'm a new beginner of DB2. I face 2 question during restore the data. I have 2 DB2 servers on my company. Server A is running on V7.2 and Server B is running on v8.2 (Enterprise...
1
by: nikb | last post by:
I am trying to restore a SQL Server database from a .dat file. An earlier question on how to do this elicited the following answer. " You need to know how the '.dat' file was created in order...
2
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
1
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
0
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
0
BLUEPANDA
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...
0
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.