Daily SQL Taks

Hi all,

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

Who is Participating?
bsharathConnect With a Mentor Commented:
bsharathConnect With a Mentor Commented:
Are you talking about Performing maintenance tasks?
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
wittysloganConnect With a Mentor Commented:
check for failed jobs
check for long running jobs
look for disk space issues especially large disk growth
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.