We Talk Coding
How to identify unused databases?
client company has around 25 sql servers . Each server has got 5 to 10 databases. Some of the databases are old. We don't know whether any applications using old databases or not. Is there any way we can find the unused databases in past 3 months or past 1 year using some Lastupdatedatetime or last action on sql server system tables using T-SQL scripts. If no application is accessing the database and no actions performed on that database from past 1 year then we need to delete that databases. How to identify unused databases? Any kind of help is greatly appreciated.
Public Comments
- Odd that they hired a company to help manage their databases yet the company they hired doesn't know how to detect database activity. You can consider hiring me. I manage several SQL database servers and business applications. :)
