SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Daily Checklist of DBA
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

hirani_prashant
Yak Posting Veteran

93 Posts

Posted - 03/19/2008 :  00:47:57  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 03/19/2008 :  07:50:06  Show Profile  Reply with Quote
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

Go to Top of Page

harsh_athalye
Flowing Fount of Yak Knowledge

India
5509 Posts

Posted - 03/19/2008 :  07:55:47  Show Profile  Visit harsh_athalye's Homepage  Click to see harsh_athalye's MSN Messenger address  Send harsh_athalye a Yahoo! Message  Reply with Quote
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"
Go to Top of Page

blindman
Flowing Fount of Yak Knowledge

USA
2365 Posts

Posted - 03/19/2008 :  09:40:50  Show Profile  Reply with Quote
First thing I do is get some coffee.

e4 d5 xd5 Nf6
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 03/19/2008 :  09:45:39  Show Profile  Reply with Quote
Take break every 30 minutes.
Go to Top of Page

elancaster
A very urgent SQL Yakette

United Kingdom
1208 Posts

Posted - 03/19/2008 :  09:48:34  Show Profile  Reply with Quote
quote:

- blindman

First thing I do is get some coffee.




...me too, then login here

Em
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 03/19/2008 :  09:53:31  Show Profile  Reply with Quote
That's Right:

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

Edited by - sodeep on 03/19/2008 09:54:18
Go to Top of Page

mdubey
Posting Yak Master

USA
133 Posts

Posted - 05/26/2008 :  20:55:41  Show Profile  Reply with Quote
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
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 05/26/2008 :  22:03:05  Show Profile  Reply with Quote
"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?

Edited by - sodeep on 05/26/2008 22:03:32
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000