How to determine the last time a database was opened

I have a request from a client to clean up and remove unused databases from their servers.

Is there a quick (easy) way to know when a database was last used by an actual user if the User Detail tracking was not turned on?

I thought about writing a postopen agent in each database and log them in a tracking database, but they don’t want to wait long enough to effectively track all the databases.

I figured a month of tracking would be good but they want to do it this week and any database not used in the past 2 weeks are to be deleted (expect mail files).

Anyone have any good ideas?

Subject: How to determine the last time a database was opened

Try the server log file (log.nsf). It has a Database\Usage view that should show you what you need.

There are also two “Usage” views that may help.

HTH

Subject: RE: How to determine the last time a database was opened

Talk about the forest and the trees. I forgot that was in there.

Thanks

Subject: RE: How to determine the last time a database was opened

I think this is also captured in the catalog.nsf