>>>>> "DJ" == David Johnson <davej@stripped> writes:
DJ> Has anyone out there figured out a good way to do database backups without
DJ> shutting down the database? We are starting a 24 X 7 (international)
DJ> service and are trying to figure out the best way to backups without
It depends on what your backups are for. Are they for archival
purposes or are they for emergency recovery?
If they are for archival purposes, then you probably will need to turn
off the updates and make your copy, otherwise you'll end up with an
inconsistent set of data, potentially.
If your backups are for emergency recovery, then you really should
consider putting your data on a RAID of some sort. Exactly which type
of RAID to use depends on your budget and performance and safety
requirements. Seeing as how you have a 24x7 operation going (don't we
all these days?) this is probably the way to go for you.
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@stripped Rockville, MD +1-301-545-6996
PGP & MIME spoken here http://www.kciLink.com/home/khera/