After Backup I loose connection to TOOLSDB

[Steven]

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

[jlb]

Hi Steve,
We are experiencing the same problem. We have IBM looking at it. Did you
find the problem?

[jlb]

Hi Steve,
We are experiencing the same problem. We have IBM looking at it. Did you
find the problem?

[Remove the obvious for replies]

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

[Remove the obvious for replies]

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

[Steven]

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?

[Steven]

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?

[Remove the obvious for replies]

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?

[Remove the obvious for replies]

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?