I confess, I was only repeating what our in-house MSSQL expert told me. While I watched, he went into Enterprise Manager and then into a dialog window (exact name forgotten) dedicated to backups. He added a short line of code that turns off the service to accommodate the backup, then turns the service back on once the backup completes. Sorry if this sounds vague, but I've only seen it one time and haven't had time to go explore it any more. This particular machine uses a competing product for backups, although we're planning to remove it and install Backup Exec instead. We abandoned NT Backup long ago.
Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mark Kirkbride Sent: Thursday, December 13, 2001 1:04 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Scheduled Datasource Updating Are you using NT backup? I think Backup Exec will back up a SQL Server on the fly, but NT backup won't. Mark Kirkbride Information System Specialist FBD Consulting, Inc. (913) 319-8836 [EMAIL PROTECTED] -----Original Message----- From: Ryan Hartwich [SMTP:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 1:00 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Scheduled Datasource Updating Keith, You can't backup your MS SQL 7 DB while it is running? That's strange....I know that you might have problems with direct tape backups to open files, but SQL 7 has a 'backup' and 'restore' function in Enterprise Manager. I use it frequently on both our development and production machines. It takes the database and dumps it, with log files I believe to a file, tape, etc. of your choice. The backup routine on a quad p3/550 takes about 10 seconds on a 50meg db (25 filled) and aobut 2? Minutes on a 1gig db with 550megs of data. Once the file is created, I usually zip the file and ftp it down to my local machines for backup on CD. Our hosting provider actually runs nightly backups, but since I'm not impressed with UUNET's service, I periodically back it up myself. Ryan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Keith Purtell Sent: Thursday, December 13, 2001 12:20 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Scheduled Datasource Updating Actually, we do something similar inside a backup procedure, because we can't back up our database while MSSQL7 is running.
winmail.dat
Description: application/ms-tnef