This is what I am leaning towards.........

However, simply stopping the service isn't enough. The tables are still
"in use".






Uwe Schreiber <Uwe.Schreiber AT DAIMLERCHRYSLER DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
02/08/2002 02:35 PM
Please respond to "ADSM: Dist Stor Manager"


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


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