Post reply

Find last access

  • June 24, 2008 at 10:39 am

    #72184

    Hi all,

    I need to attempt to find out when the last time a particular database was accessed by anyone. Given that there are no 'special' logging processes (and certainly no traces) carrying on on this server/database, and the transaction logs will not help unless the last user changed something (and if it's being used at all it will be 99+% for reference only), I'm not sure it's possible. Only want a ball-park figure, can't find anything useful in event viewer. Any thoughts?

    Thanks in advance.

  • June 24, 2008 at 11:08 am

    #833475

    As you already suspected, In SQL2000, there's not much you can do.

    If all your databases have the database recovery model set to "FULL" instead of "SIMPLE", you could use a log reading program to find anything that had changes in each database.

    I'm sure the logs would not have any info from where people did simple SELECT statements and then stopped using the database. that's not logged.

    Otherwise, you'd need to start running a trace to capture login information , so you could capture it going forward, but not based on past data.

    In 2005, there's a lot you can do with triggers and auditing.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 25, 2008 at 1:56 am

    #833748

    Sadly that's pretty much what I'd concluded. Thanks anyway for giving it some thought.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply