This is what I am leaning towards.........
However, simply stopping the service isn't enough. The tables are still
"in use".
Uwe Schreiber <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
02/08/2002 02:35 PM
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
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
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08.02.2002 20:29
Please respond to ADSM-L
To: [EMAIL PROTECTED]
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
Virginia Commonwealth University - University Computing Center
e-mail: [EMAIL PROTECTED] - voice: 804-828-4807
