Re: Backing up MS-SQL without the TDP
2002-02-08 14:48:53
Subject: |
Re: Backing up MS-SQL without the TDP |
From: |
Zoltan Forray/AC/VCU <zforray AT VCU DOT EDU> |
Date: |
Fri, 8 Feb 2002 14:51:46 -0500 |
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
|
|
|