Geoff,

Correct me if I am wrong...but they are referring to
using the BA client, not TDP for SQL (SQL Agent).

TDP for SQL takes online backups of databases.

I think they are trying to take a backup of the SQL databases
by bringing the SQL server down, backing up the database
files with the base client, then restarting the SQL server.
Some folks have the luxury of doing that while others
must have the SQL databases available 24x7 and cannot bring them
down to do an "offline" backup.

Thanks,

Del

----------------------------------------------------
Del Hoobler
Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com


"Gill, Geoffrey L." <GEOFFREY.L.GILL AT SAIC DOT COM>@VM.MARIST.EDU> on 
08/15/2000
09:26:05 AM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:   ADSM-L AT VM.MARIST DOT EDU
cc:
Subject:  Re: Base TMS client and SQL backup question



>         If you are not using the net commands, how are you using the
> pre/post (or other methods) commands to stop the SQL server
> so the databases can be backed up?

Gary,

I'm using the agent to back up our databases, but we don't issue any
pre/post commands to stop and start SQL. I thought the whole idea of this
agent was to backup the database while it was online. I also thought it
would do any such thing on it's own if need be. Now that you've raised the
question I wonder if I'm missing something.

I can say that I've sucessfully restored databases direct to their original
location without any problems too. As early as yesterday I had a DBA on the
phone. Just after I restored one database he told me it was fine. Since I
haven't had any problems I'm only guessing I've been doing things right.

Geoff