Checking Active DBs

• carloarango@hotmail.com

  SSChasing Mays

  Points: 628

  More actions

  January 26, 2011 at 1:11 pm

  #142194

  We are in the process of cleaning up some of our SQL Servers by dropping DBs that have been inactive for a while; what is the best way to find out which DBs are currently active or when was the last time a DB was been accessed accessed and/or modified?

  Thanks

• AlexSQLForums

  SSChampion

  Points: 14256

  More actions

  January 26, 2011 at 2:23 pm

  #1278794

  Robin Back has a script for that.

  http://qa.sqlservercentral.com/scripts/Miscellaneous/30871/[/url]

  Alex S

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  January 26, 2011 at 4:01 pm

  #1278848

  Use Performance Dashboard Reports.

  Thank You,

  Best Regards,

  SQLBuddy