DBA Tasks

• sql_Reporter

  SSCrazy

  Points: 2329

  More actions

  April 16, 2012 at 7:56 am

  #267447

  Hi guys,

  I've been asked to do a check of all the SQL DB servers.

  the checks will be:

  1. Daily

  2. Weekly

  3. Monthly

  I've a list of items that i want to check. Is there any free tools avaiable to help me acheive this task or a dashboard

  The Main items are

  Connectivity

  Integrity

  Backups

  Disk Space

  Security

• kapfundestanley

  SSCertifiable

  Points: 5637

  More actions

  April 17, 2012 at 2:48 am

  #1474573

  Back-ups and Integrity you can use maintenance plans.

  “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

• heymiky

  SSCarpal Tunnel

  Points: 4875

  More actions

  April 17, 2012 at 3:51 am

  #1474596

  A colleague of mine wrote one, look at this http://www.enterprisedba.com/