By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,190 Members | 1,653 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,190 IT Pros & Developers. It's quick & easy.

After Backup I loose connection to TOOLSDB

P: n/a
I am running V8 fp 4a on a W2K Server.
I generated a script from CC to backup up my database and got the
following:
CONNECT TO EDPACKD;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
CONNECT RESET;
BACKUP DATABASE EDPACKD TO "C:\SQLLIB\" WITH 1 BUFFERS BUFFER 1024
PARALLELISM 1 WITHOUT PROMPTING;
CONNECT TO EDPACKD;
UNQUIESCE DATABASE;
CONNECT RESET;

This runs fine and I get the backup. The problem is that I loose my
ability to pull up the Task Center and also to connect to the TOOLSDB.
When I try to connect I get SQL1391N "The database is already in use
by another Instance". The database I am backing up and the toolsdb are
both in the same instance is that the problem? Any ideas would be
greatly appreciated.

Thank you
Nov 12 '05 #1
Share this Question
Share on Google+
8 Replies


P: n/a
jlb
Hi Steve,
We are experiencing the same problem. We have IBM looking at it. Did you
find the problem?

Nov 12 '05 #2

P: n/a
jlb
Hi Steve,
We are experiencing the same problem. We have IBM looking at it. Did you
find the problem?

Nov 12 '05 #3

P: n/a
I think everyone on W2K has that problem. I opened a PMR and was told
it was related to the QUIESCE DATABASE statement and would be fixed in
FP6. For now, don't use QUIESCE...

On 3 Apr 2004 07:56:49 -0800, ra*******@yahoo.com (Steven) wrote:
I am running V8 fp 4a on a W2K Server.
I generated a script from CC to backup up my database and got the
following:
CONNECT TO EDPACKD;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
CONNECT RESET;
BACKUP DATABASE EDPACKD TO "C:\SQLLIB\" WITH 1 BUFFERS BUFFER 1024
PARALLELISM 1 WITHOUT PROMPTING;
CONNECT TO EDPACKD;
UNQUIESCE DATABASE;
CONNECT RESET;

This runs fine and I get the backup. The problem is that I loose my
ability to pull up the Task Center and also to connect to the TOOLSDB.
When I try to connect I get SQL1391N "The database is already in use
by another Instance". The database I am backing up and the toolsdb are
both in the same instance is that the problem? Any ideas would be
greatly appreciated.

Thank you


Nov 12 '05 #4

P: n/a
I think everyone on W2K has that problem. I opened a PMR and was told
it was related to the QUIESCE DATABASE statement and would be fixed in
FP6. For now, don't use QUIESCE...

On 3 Apr 2004 07:56:49 -0800, ra*******@yahoo.com (Steven) wrote:
I am running V8 fp 4a on a W2K Server.
I generated a script from CC to backup up my database and got the
following:
CONNECT TO EDPACKD;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
CONNECT RESET;
BACKUP DATABASE EDPACKD TO "C:\SQLLIB\" WITH 1 BUFFERS BUFFER 1024
PARALLELISM 1 WITHOUT PROMPTING;
CONNECT TO EDPACKD;
UNQUIESCE DATABASE;
CONNECT RESET;

This runs fine and I get the backup. The problem is that I loose my
ability to pull up the Task Center and also to connect to the TOOLSDB.
When I try to connect I get SQL1391N "The database is already in use
by another Instance". The database I am backing up and the toolsdb are
both in the same instance is that the problem? Any ideas would be
greatly appreciated.

Thank you


Nov 12 '05 #5

P: n/a
kurt.wood@NO**@M.state.mn.us (Remove the obvious for replies) wrote in message news:<40**************@news.state.mn.us>...
I think everyone on W2K has that problem. I opened a PMR and was told
it was related to the QUIESCE DATABASE statement and would be fixed in
FP6. For now, don't use QUIESCE...


This is a problem if you have the toolsdb in the same instance that
the database you want to back up is in. You can't do a force
applications all or you kill the script trying for the backup. Do you
have a script that is running to perform the backup through task
center?
Nov 12 '05 #6

P: n/a
kurt.wood@NO**@M.state.mn.us (Remove the obvious for replies) wrote in message news:<40**************@news.state.mn.us>...
I think everyone on W2K has that problem. I opened a PMR and was told
it was related to the QUIESCE DATABASE statement and would be fixed in
FP6. For now, don't use QUIESCE...


This is a problem if you have the toolsdb in the same instance that
the database you want to back up is in. You can't do a force
applications all or you kill the script trying for the backup. Do you
have a script that is running to perform the backup through task
center?
Nov 12 '05 #7

P: n/a
I am running the TOOLSDB in the same instance as my production DB's.
Here is the script I use (it does a bit more than just backups
though!) :

! SC \\MDA_IMS STOP "ArcIMS Tasker 4.0" %
! SC \\MDA_IMS STOP "ArcIMS Monitor 4.0" %
! SC \\MDA_IMS STOP "ArcIMS Application Server 4.0" %

! SC STOP esri_sde %

FORCE APPLICATION ALL %
;CONNECT TO WEBDATA %
;QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS %
;CONNECT RESET %
BACKUP DATABASE WEBDATA TO "F:\mdaback\" WITH 5 BUFFERS BUFFER 1024
PARALLELISM 1 WITHOUT PROMPTING %
;CONNECT TO WEBDATA %
;UNQUIESCE DATABASE %
;CONNECT RESET %

;CONNECT TO MDA_PROD %
;QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS %
;CONNECT RESET %
BACKUP DATABASE MDA_PROD TO "F:\mdaback\" WITH 5 BUFFERS BUFFER 1024
PARALLELISM 1 WITHOUT PROMPTING %
;CONNECT TO MDA_PROD %
;UNQUIESCE DATABASE %
;CONNECT RESET %

! SC START esri_sde %
! D:\Sleep\sleep.exe 30000 %

! SC \\MDA_IMS START "ArcIMS Application Server 4.0" %
! SC \\MDA_IMS START "ArcIMS Monitor 4.0" %
! SC \\MDA_IMS START "ArcIMS Tasker 4.0" %

! F:\BU_SCRIPT\filemove.bat %

--- Compresses the SDE Geodatabase - Added 4/9/2004 KW
! D:\arcgis\ArcSDE\db2exe\bin\sdeversion -o compress -u sde -p ******
-N -s mdadb -i 5151 %
---
On 6 May 2004 10:44:29 -0700, ra*******@yahoo.com (Steven) wrote:
kurt.wood@NO**@M.state.mn.us (Remove the obvious for replies) wrote in message news:<40**************@news.state.mn.us>...
I think everyone on W2K has that problem. I opened a PMR and was told
it was related to the QUIESCE DATABASE statement and would be fixed in
FP6. For now, don't use QUIESCE...


This is a problem if you have the toolsdb in the same instance that
the database you want to back up is in. You can't do a force
applications all or you kill the script trying for the backup. Do you
have a script that is running to perform the backup through task
center?


Nov 12 '05 #8

P: n/a
I am running the TOOLSDB in the same instance as my production DB's.
Here is the script I use (it does a bit more than just backups
though!) :

! SC \\MDA_IMS STOP "ArcIMS Tasker 4.0" %
! SC \\MDA_IMS STOP "ArcIMS Monitor 4.0" %
! SC \\MDA_IMS STOP "ArcIMS Application Server 4.0" %

! SC STOP esri_sde %

FORCE APPLICATION ALL %
;CONNECT TO WEBDATA %
;QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS %
;CONNECT RESET %
BACKUP DATABASE WEBDATA TO "F:\mdaback\" WITH 5 BUFFERS BUFFER 1024
PARALLELISM 1 WITHOUT PROMPTING %
;CONNECT TO WEBDATA %
;UNQUIESCE DATABASE %
;CONNECT RESET %

;CONNECT TO MDA_PROD %
;QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS %
;CONNECT RESET %
BACKUP DATABASE MDA_PROD TO "F:\mdaback\" WITH 5 BUFFERS BUFFER 1024
PARALLELISM 1 WITHOUT PROMPTING %
;CONNECT TO MDA_PROD %
;UNQUIESCE DATABASE %
;CONNECT RESET %

! SC START esri_sde %
! D:\Sleep\sleep.exe 30000 %

! SC \\MDA_IMS START "ArcIMS Application Server 4.0" %
! SC \\MDA_IMS START "ArcIMS Monitor 4.0" %
! SC \\MDA_IMS START "ArcIMS Tasker 4.0" %

! F:\BU_SCRIPT\filemove.bat %

--- Compresses the SDE Geodatabase - Added 4/9/2004 KW
! D:\arcgis\ArcSDE\db2exe\bin\sdeversion -o compress -u sde -p ******
-N -s mdadb -i 5151 %
---
On 6 May 2004 10:44:29 -0700, ra*******@yahoo.com (Steven) wrote:
kurt.wood@NO**@M.state.mn.us (Remove the obvious for replies) wrote in message news:<40**************@news.state.mn.us>...
I think everyone on W2K has that problem. I opened a PMR and was told
it was related to the QUIESCE DATABASE statement and would be fixed in
FP6. For now, don't use QUIESCE...


This is a problem if you have the toolsdb in the same instance that
the database you want to back up is in. You can't do a force
applications all or you kill the script trying for the backup. Do you
have a script that is running to perform the backup through task
center?


Nov 12 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.