Check for inactive database

Hi

I am working at a site that has no dedicated DBA, and our Sql Server 2000 environment has recently been playing up. There are several databases on the Production server that should be inactive (for applications no longer used).

What is the best way for me to see if there has been any recent activity on these databases (short of taking them offline and waiting for screams). Please keep in mind that I am a Sql Server novice.

Cheers

AFAIK ....there is no simple method or query to find which database is used when. The best method is to run profiler/Trace and see

Madhu

|||You can check the last modified date of the phyiscal files. Im not sure abt this..
|||

Hey

Thanks for your responses. As suggested, I am using Profiler to watch the db for a period of time.

Cheers

Alec

|||When I face the problem you are facing, I change the status of the database to Offline, and then see if anybody notices. If nobody complains after a week/month or so, I remove the databases. If someone screams, it is then easy to identify who is using the database you think should not be in use.sql