SEO

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

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

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, ragingpug@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

kurt.wood@NOSP@M.state.mn.us (Remove the obvious for replies) wrote in message news:<409a2e0b.1798140@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?

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, ragingpug@yahoo.com (Steven) wrote:

>kurt.wood@NOSP@M.state.mn.us (Remove the obvious for replies) wrote in message news:<409a2e0b.1798140@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?