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. ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED]
