Re: Running Optimizations daily instead of weekly

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Brent White (bwhite_at_badgersportswear.com)
Date: 01/28/05 

Date: Fri, 28 Jan 2005 10:23:36 -0800

I thought about Index_Defrag.

The system is not a 24x7 operation YET, but at some point it could be.
Right now, I make a daily backup to CD of the database (I have a whole
stack of backup CD's), so if SQL Server messes it up I can immediately
restore.

What would the defrag operation do that the reindex operation would not?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Restore Portal to different name on same machine?
    ... I have scripted a daily backup using the ... Backup and Restore Utility. ... It only lists the names of the portals that were backed up. ...
    (microsoft.public.sharepoint.portalserver)
  • Restore from .bkf
    ... I do have a daily backup of C:, info store, and system state to ... restore system state first, second or last? ...
    (microsoft.public.windows.server.sbs)