I would also buy a super-super-fast computer to do just the reindexing and backups. Any increase in CPU should be able to lower a job like that by hours.
--- On Sat, 8/1/09, Stephen Russell <[email protected]> wrote: > From: Stephen Russell <[email protected]> > Subject: Re: [NF] love those db backups that span days. :( > To: "ProFox Email List" <[email protected]> > Date: Saturday, August 1, 2009, 8:43 AM > 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 > > > _______________________________________________ > 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/[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. > _______________________________________________ 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/[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.
