You can get the SQL agent if you want to do an ONLINE backup but you do not have to. The online backup is prefomred 3 times a day just in case we have a failure in the middle of the day we will atleast have data up to a certain point. Your deciding factor is what amount of data are you willing to lose. Most people say none and that is the ideal world but there is always about a 5-8 hour lapse that we are willing to lose. I built this backup strategy and we follow it to a T with only one disaster in our pocket. We were actually lucky because I was able to ghost the data stripe set and we lost no data. Had a controller failure that would not take a reinstall and the only way to get anything to work was a compaq erase.<shiver up spine> But if it ever happened to where we could not get the data off we would have lost only about 5 hours worth of data.
Josh -----Original Message----- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 4:28 PM To: CF-Talk Subject: RE: Backups II, the Sequel I guess this begs the question: Clearly Veritas Pro can handle backing up my local server, mdbs and all. And I can get my SQL 2000 box to put a backup in an accessible directory, too. Do I then get the SQL agent, on top of that? Sorry to put these questions here but this is all a little new to me... -----Original Message----- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 1:22 PM To: CF-Talk Subject: RE: Backups II, the Sequel On a daily basis we have what we call an online back where we allow sql to backup to the local drive then we backup those files. We then on sunday stop the sql service and backup the entire server. On critical servers we do the same with the exception of an online backup in which we use the veritas sql agent which will go into a db and back it up. Josh -----Original Message----- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 4:01 PM To: CF-Talk Subject: OT: Backups II, the Sequel OK, now that I've figured out we need better backup software - what's a good program to: 1. Backup the local server 2. AND backup SQL data on another server Ian Portent Interactive Helping clients build customer relationships on the web since 1995 Consulting, design, development, measurement http://www.portentinteractive.com Talk with us: http://projects.portentinteractive.com ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists