Daily SQL Taks

Hi all,

What are some of the dalily tasks I should be doing for SQL 2000?  

Thanks!
oxburgerAsked:
Who is Participating?
 
bsharathConnect With a Mentor Commented:
0
 
bsharathConnect With a Mentor Commented:
Are you talking about Performing maintenance tasks?
http://www.mssqltips.com/tip.asp?tip=1013
0
 
imitchieConnect With a Mentor Commented:
these are the most common tasks:

do a daily statistics update, and index rebuild (most table)
for the largest tables, index rebuild every week
backup all databases every day
0
 
wittysloganConnect With a Mentor Commented:
check for failed jobs
check for long running jobs
look for disk space issues especially large disk growth
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.