Old sql 2000 Databases.. Last time updated? Last time accessed

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jc - 30 Sep 2008 19:39 GMT

We have a server with some 100 sql 2000 Databases.

How can I tell the last time a database was updated? accessed?

Will the mod date on the data file be a clue? how about the mod date
on the log file?

Is there anywhere I can extract access logs for the entire instance?

Thanks.

Reply to this Message

John Bell - 30 Sep 2008 21:49 GMT

> We have a server with some 100 sql 2000 Databases.
>
[quoted text clipped - 6 lines]
>
> Thanks.

Hi

AFAIK there is no way to determine this, unless your application stores
access information. If you have maintainance/backups etc these will "access"
the database and SQLServer probably wouldn't be able to tell the difference.
The other thing that may have helped would be the C2 auditing features, but
I suspect you aren't using them.

John

Reply to this Message

Eric Isaacs - 30 Sep 2008 22:33 GMT

There are some 3rd party tools that will help you read the SQL Server
logs. They would only help you determine what has changed in the db.
I doubt you would find traces of logins in the logs if someone just
came in and read or extracted some data.

Here's just one example:
http://www.quest.com/Quest_Site_Assets/PDF/LogReaderForSQLServer_ReleaseNotes.htm

-Eric Isaacs

Reply to this Message