Automated Shut Down/Restart of DB

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Mike Sydney (MikeSydney_at_discussions.microsoft.com)
Date: 12/10/04 

Date: Fri, 10 Dec 2004 09:41:07 -0800

I have a client management system that has Sybase ASA database engine running
under Windows 2000 Server. The backup program (Veritas Back-up Exec) that we
use on our server will not back up Sybase while it is still running. We have
to manually shut down the database from the console before taking a backup
each night and then restart it every morning manually.
I would like to automate this task. Is there a way I can execute the shut
down program through a batch file using the Windows Task scheduler before the
Back-up job runs (11:00pm) and then execute the start-up program after the
back-up job runs say at 6:00am? If this possible how would I do this? or
perhaps there is a better way to this? The vendors offer no help...
   Thanks

Relevant Pages

  • Automated Back-up of Server
    ... I have a client management system that has Sybase ASA database engine running ... under Windows 2000 Server. ... The backup program that we ... use on our server will not back up Sybase while it is still running. ...
    (microsoft.public.windows.server.general)
  • backup error
    ... I get the following error on my Windows 2003 Server when trying to use the Backup program in Windows to back up an Exchange 2003 Server: ... Information Store First Storage Group: The backup has stopped with error -521. ...
    (microsoft.public.exchange.misc)
  • Re: How to grant volume shadow copy permission ?
    ... We have a Windows 2003 domain with Windows XP clients. ... the normal users to be able to run a backup program which uses the ... The server where volume shadow copy is enabled can be set up ...
    (microsoft.public.windowsxp.security_admin)
  • Backup Software
    ... I have a server at a non-profit organization that needs backup software -- something that is more reliable and has more features than the silly backup program that is included in Windows 2003 Server. ...
    (microsoft.public.windows.server.setup)
  • SecurityFocus Microsoft Newsletter #154
    ... MICROSOFT VULNERABILITY SUMMARY ... ISS RealSecure Server Sensor SSL Denial Of Service Vulnerabi... ... Roger Wilco Remote Server Side Buffer Overrun Vulnerability ... available for Microsoft Windows operating systems. ...
    (Focus-Microsoft)