473,386 Members | 1,708 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 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 1058
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...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.