April 22, 2005 at 8:32 am
I work in an environment in which developers create multiple databases on a single shared server. Our IT folks go nuts trying to save disk space by getting users to delete unused databases. However, we have no way of knowing the last time a db was accessed.
Is there any program or sp that we could run periodically that would return the last time a database was accessed?
Thanks
April 27, 2005 at 11:58 am
Unfortunately, SQL Server has no built-in capability to help you here. There are several third party tools that can do this (or approximate this functionality) InDepth for SQL Server by Veritas can be used for this and Entegra by Lumigent can as well.
I suppose that if you had basically a one to many relationship between your databases and your logins you could turn on auditing for successful logins and that could give you an idea, but that situation doesn't often apply in my experience.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply