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.
______________________________________________________________________
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]
______________________________________________________________________
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]
