Most industrial strength backup systems don't do a complete overright every night. The first time through, the backup can take several days, but after that the software just pulls the updates. Otherwise, you'd be into that multiple day backup every night, and that's not doable when backing up tbytes and storing in a remote san. I hate backup, whether it is to a local disk, a san, or (and especially) if sending to tape. Tape is the worst medium possible, as it will lie to you. The tape can become unreadable at any time, you can't easily view the files you think you backed up, etc. etc. etc.
John Harvey -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Stephen Russell Sent: Saturday, August 01, 2009 7:43 AM To: ProFox Email List Subject: Re: [NF] love those db backups that span days. :( On Sat, Aug 1, 2009 at 3:46 AM, John Weller<[email protected]> wrote: > But surely part of any sensible backup strategy includes at least a partial > restore at intervals to prove the integrity of the backup? > > I heard a story from an acquaintance of visiting an establishment and > enquiring how they backed up their financial data. He was told that they > backed up every night to tape and had done so for 3 years - but they kept > getting an error message that they didn't understand so they ignored it. > The message was "Tape not formatted". ---------------------- The company I am working for has a lot of small clients and doing a daily full backup on good equipment takes under 30 min for most of the accounts. This one is huge and does not fit the standard so they have a hard time with it. hahahaha So the backup took 30 hours to run. Which is out of control from my POV. They have a chatty switch port as guess. Or there is some other process that they are forgetting to tell me about with the SAN. This weekend they are doing some maintenance on this situation. So we will see. They are stuck with a daily process that has to run after midnight to post the current day's activities and other stuff. They have a massive reindex process that runs weekly and it takes under 5 hours. If we do the Weekly Full and Daily Incremental I have to switch all the days of the week and times for all the processes. They don't understand how to work this all together. -- Stephen Russell Sr. Production Systems Programmer SQL Server DBA Web and Winform Development Independent Contractor Memphis TN 901.246-0159 [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/029501ca12af$8ebe66a0$ac3b33...@[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
