DB maint task document

Question

Post reply

DB maint task document

HBK_4700

SSCrazy Eights

Points: 8932
More actions
September 17, 2009 at 2:17 pm

#156233

I am trying to create a SQL 2005 db maintenance tasks document. Can anyone provide me inputs/ouputs and/or basic template. I will appreciate it.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Dugi SSCoach Points: 17998 More actions · Answer 1

Ok I post some topics but in general, try to find more info from BOL:

1. Backups

2. Disk Space

3. Job Failures

4. System Checks

5. Performance

6. Connectivity

7. Replication ( If you have )

-

8. Security Checks (by Silverfox)

9. Data file and log file growth rate % (by Henrico Bekker)

10. Errors relating to SQL in Windows Logs ((by Henrico Bekker)

I edited the post adding also other suggestions from the friends of this post ...thnx!

:hehe:

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 2

chk2009 (9/17/2009)
I am trying to create a SQL 2005 db maintenance tasks ddocument. Can anyone provide me inputs/ouputs and/or basic template. I will appreciate it.

Can you explain it a bit for what purpose you are preparing this document?

I mean, is it just the infomatery or somebody is going to perform actions based on the instructions/step right from the document?

-Forum Etiquette: How to post Performance Problems[/url]

-Forum Etiquette: How to post data/code to get the best help [/url]

Silverfox SSC-Insane Points: 23150 More actions · Answer 3

Dugi (9/18/2009)
Ok I post some topics but in general, try to find more info from BOL:
1. Backups
2. Disk Space
3. Job Failures
4. System Checks
5. Performance
6. Connectivity
7. Replication ( If you have )
:hehe:

You could also add security checks which is more server level but still important as well as log shipping or clustering

--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 4

Dugi (9/18/2009)
Ok I post some topics but in general, try to find more info from BOL:
1. Backups
2. Disk Space
3. Job Failures
4. System Checks
5. Performance
6. Connectivity
7. Replication ( If you have )
:hehe:

May I add:

8. Data file and log file growth rate %

9. Errors relating to SQL in Windows Logs

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle