You can schedule SQL to create backups of your databases to a directory before TSM starts it backup (TSM can pick up the backup files). You can then restore the databases into a fresh copy of SQL if needed. Check the Microsoft site for procedures for this (restore from backup). This worked fine (abit longer to restore) in your DR testing.
We dont use TDP for SQL, again $$$ is a factor... Joe Cascanette The Cumis Group Limited -----Original Message----- From: Zoltan Forray/AC/VCU [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 2:31 PM To: [EMAIL PROTECTED] 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
