Daily Checklist of DBA - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Daily Checklist of DBA

Author

Topic

hirani_prashant
Yak Posting Veteran

93 Posts

Posted - 2008-03-19 : 00:47:57

Hello All,

What should i have to check as a DBA at every new day. Is any one having scripts for the checklist then please send me that scripts.

Thanks
Prashant Hirani

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-19 : 07:50:06

Here are the best one I like:

http://www.mssqltips.com/tip.asp?tip=1240
http://vyaskn.tripod.com/sql_server_administration_best_practices.htm

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-03-19 : 07:55:47

If you mean Admin DBA, here are some of the things you can consider as your daily tasks:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72699&SearchTerms=dba

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2008-03-19 : 09:40:50

First thing I do is get some coffee.

e4 d5 xd5 Nf6

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-19 : 09:45:39

Take break every 30 minutes.

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-03-19 : 09:48:34

quote:

- blindman

First thing I do is get some coffee.

...me too, then login here

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-19 : 09:53:31

That's Right:

1) Get some coffee.
2) Check some personal mail
3) Login to SQLteam.com

mdubey
Posting Yak Master

133 Posts

Posted - 2008-05-26 : 20:55:41

I would say you may need to check couple of thing for daily check list.

1) create job and configure an email alert for all jobs related to SQL server.
2) check for the Job list report.
3) Check for the DB online status.

This is not all the things, there are too more things to check....

Manoj
MCP, MCTS

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-26 : 22:03:05

"I would say you may need to check couple of thing for daily check list.

1) create job and configure an email alert for all jobs related to SQL server.
2) check for the Job list report.
3) Check for the DB online status.

This is not all the things, there are too more things to check...."

Has already been answered. Will you please see what others have posted before you post?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources