There is a one day window on my production server opening tomorrow - server
is in dire need of maintenence. Planned are defrags, index rebuilds,
backups, and the trial of a backup software with compression (we have a spac
e
problem as well). Experienced DBA's probably know some items that are
critical to address when this opportunity arises. Please help me with
general suggestions.
--
Regards,
JamieActivities in order of priority:
Caffeine delivery vehicle of choice (coffee, Jolt, Red Bull, Tea)
Backups
Necessary Service Packs and/or Patches to OS
Necessary Service Packs and/or Patches to SQL Server.
More Caffeine
If filegroups need to be reorganized, do so
Add New data files if needed
Defrag data files if needed
Towel to wipe sweat from brow
More caffeine
Rebuild any Indexes needing rebuild
Defrag Indexes
Test New Backup software
Backups
Nearest Pub for Beverage of choice
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"thejamie" <thejamie@.discussions.microsoft.com> wrote in message
news:A973D6AF-ABB8-451E-9A17-5A5492F5D117@.microsoft.com...
> There is a one day window on my production server opening tomorrow -
> server
> is in dire need of maintenence. Planned are defrags, index rebuilds,
> backups, and the trial of a backup software with compression (we have a
> space
> problem as well). Experienced DBA's probably know some items that are
> critical to address when this opportunity arises. Please help me with
> general suggestions.
> --
> Regards,
> Jamie|||Thanks Arnie. Matches my list. Assures me I'm on track.
--
Regards,
Jamie
"Arnie Rowland" wrote:
> Activities in order of priority:
> Caffeine delivery vehicle of choice (coffee, Jolt, Red Bull, Tea)
> Backups
> Necessary Service Packs and/or Patches to OS
> Necessary Service Packs and/or Patches to SQL Server.
> More Caffeine
> If filegroups need to be reorganized, do so
> Add New data files if needed
> Defrag data files if needed
> Towel to wipe sweat from brow
> More caffeine
> Rebuild any Indexes needing rebuild
> Defrag Indexes
> Test New Backup software
> Backups
> Nearest Pub for Beverage of choice
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to th
e
> top yourself.
> - H. Norman Schwarzkopf
>
> "thejamie" <thejamie@.discussions.microsoft.com> wrote in message
> news:A973D6AF-ABB8-451E-9A17-5A5492F5D117@.microsoft.com...
>
>
No comments:
Post a Comment