October 13, 2008 at 9:18 am
Is anyone have a list of things/jobs set up that could give me what I need to set up to keep my servers healthy.Thank you
October 13, 2008 at 9:29 am
What's your idea of "healthy"?
I see that used, but it could mean many things. A short list of stuff I'd do first.
1. Make sure backups are being run.
2. Make sure you can restore backups (meaning test).
3. Set torn page detection and run dbcc checkdb regularly.
4. Make sure you have alerting on your jobs so you can respond to things.
5. Make sure you have enough space in your data/log files to last a month or two.
6. Make sure you check every month or two for space in the data files and disk space.
October 13, 2008 at 10:01 am
I'll add to that
7) Set up some performance monitoring so that you can establish a baseline of what's normal and what's not
8) Schedule index rebuilds/defrags as necessary
9) If in full recovery, make sure you have log backups running
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply