Hi,

you have the coice.

1. Make an online backup of your database to disk using the provided
machenism of SQL-Server,
    and the backup will be during the normal scheduled backup.

or

2. Stop the Services for MS-SQL during a PRECOMMANDSCHEDULE. You can use
the mentioned SC.EXE tool
    provided by the NT Resource Kit, scripted to stop the services.
    After the offline-backup, use a POSTCOMMANDSCHEDULE. You can use the
SC.EXE tool, scripted to start the services.

Regards,
Uwe Schreiber





zforray AT VCU DOT EDU
Sent by: ADSM-L AT VM.MARIST DOT EDU
08.02.2002 20:29
Please respond to ADSM-L


        To:     ADSM-L AT VM.MARIST DOT EDU
        bcc:
        Subject:        Backing up MS-SQL without the TDP

Has anyone got a working procedure they use to backup a server with MS-SQL
on it, without using the TDP ?  We can't afford to by any more licenses of
the TDP.

I realize there is an SC.EXE program that can be used to shut-down and
start the SQL process.

Any help would be appreciated.
--------------------------------------------------------------------------------
---------
----------
----------
---------- Zoltan Forray
---------- Zoltan Forray
Virginia Commonwealth University - University Computing Center
Virginia Commonwealth University - University Computing Center
e-mail: zforray AT vcu DOT edu  -  voice: 804-828-4807