Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Stop/Start Adaptive Server v6

2 posts in General Discussion Last posting was on 2002-09-06 16:02:45.0Z
melayna Posted on 2002-09-06 13:48:42.0Z
From: melayna
Date: Fri, 6 Sep 2002 09:48:42 -0400
Newsgroups: ianywhere.public.general
Subject: Stop/Start Adaptive Server v6
Message-ID: <A0CA01DB7A50CF97004BDEC985256C2C.004BDED985256C2C@webforums>
Lines: 8
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:633
Article PK: 3170

Does anyone know the best way to issue a stop and/or start commands on the
server for nightly backups. In SQL 2000 there are scm commands that can be
run that will do this. A command line can be enter in a schedule tasks.
The only way that I have found this to be successfully in Win 2000 server
is to create batch files. One for the stop and one for the start. This
works, but when my start-up command initializes, it leaves the MSDOS window
on the screen. In SQL 2000 you can put a silent switch on the command and
the batch file will run smoothly. Any ideas on the best way to do this,
besides batch files??


Robert Waywell Posted on 2002-09-06 16:02:45.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <A0CA01DB7A50CF97004BDEC985256C2C.004BDED985256C2C@webforums>
Subject: Re: Stop/Start Adaptive Server v6
Date: Fri, 6 Sep 2002 12:02:45 -0400
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <ilQZ6CcVCHA.74@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:629
Article PK: 3174

An alternative is to run dbbackup to do the backup and then have your tape
backup copy the backup of the db files rather than the originals.

--
-----------------------------------------------
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://casexpress.sybase.com/cx/cx.stm

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

<melayna> wrote in message
news:A0CA01DB7A50CF97004BDEC985256C2C.004BDED985256C2C@webforums...
> Does anyone know the best way to issue a stop and/or start commands on the
> server for nightly backups. In SQL 2000 there are scm commands that can
be
> run that will do this. A command line can be enter in a schedule tasks.
> The only way that I have found this to be successfully in Win 2000 server
> is to create batch files. One for the stop and one for the start. This
> works, but when my start-up command initializes, it leaves the MSDOS
window
> on the screen. In SQL 2000 you can put a silent switch on the command and
> the batch file will run smoothly. Any ideas on the best way to do this,
> besides batch files??