|
Home > Archive > SQL Anywhere database replication > April 2005 > How to pause or stop dbremote?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to pause or stop dbremote?
|
|
| Joanna 2005-04-20, 7:23 am |
| Hi all,
I have set up one consolidated database and 2 remote databases, and I have
started the SQL remote in continuous mode.
There is a process (say process A) which is easily failed when it is not
properly set up before running, Therefore, I do a backup on the consolidated
database, shutdown all SQL remotes (by clicking the Shutdown button) and run
process A.
If process A completed successfully, I can then restart all SQL remotes and
the changes made during process A can be replicated to those remote
databases. But if process A failed, I only have to restore the consolidated
database as the remote databases is not modified with the SQL remote
shutdown.
Now my problem is, how to automate this shutdown and restart process of SQL
remote? I'm using ASA 7.03. Thanks in advance.
--
Regards,
Joanna Wan
| |
| Rob Waywell 2005-04-20, 9:23 am |
| Please do not crosspost.
I have already replied to this post in the sybase.public.sqlanywhere.general
newsgroup. You are correct that this would be the better newsgroup for
further SQL Remote questions.
--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional
Sybase's iAnywhere Solutions
Please respond ONLY to newsgroup
EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all
To Submit Bug Reports:
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288
Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer
"Joanna" <joanna.wan@caplogic.com> wrote in message
news:426624f8$1@foru
ms-2-dub...
> Hi all,
>
> I have set up one consolidated database and 2 remote databases, and I have
> started the SQL remote in continuous mode.
> There is a process (say process A) which is easily failed when it is not
> properly set up before running, Therefore, I do a backup on the
consolidated
> database, shutdown all SQL remotes (by clicking the Shutdown button) and
run
> process A.
> If process A completed successfully, I can then restart all SQL remotes
and
> the changes made during process A can be replicated to those remote
> databases. But if process A failed, I only have to restore the
consolidated
> database as the remote databases is not modified with the SQL remote
> shutdown.
>
> Now my problem is, how to automate this shutdown and restart process of
SQL
> remote? I'm using ASA 7.03. Thanks in advance.
>
> --
> Regards,
> Joanna Wan
>
>
|
|
|
|
|