Link to home
Start Free TrialLog in
Avatar of itgroove
itgrooveFlag for Canada

asked on

How to identify inactive SQL Databases

I require a SQL Script or some other method for finding out which databases in a SQL Server are the "least" active (or completley dormant). I.e. my problem is that I have a number of databases left over after a few SharePoint installs (which are now long gone) all with cryptic serialized database names. I don't want to delete the wrong databases for those that are still active.
ASKER CERTIFIED SOLUTION
Avatar of Adam Menkes
Adam Menkes
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of ProjectChampion
ProjectChampion
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of itgroove
itgroove
Flag of Canada image

ASKER

LOL, thanks.  CV is always up to date.  I have all my ducks in a row and these extra DB's could be manually identified but I like the script idea first (after testing), at least as a "glance" of what is going on.

Thanks folks.