How to check if Database is still being used

  • Dear all - I'm currently trying to decommision a number of SQL2005 Servers & there are historical DB's which knowone seems to know anything about it. Is there an easy way of establishing whether or not a database is being used.

    Many thanks

    Dax

  • Trace for a sensible period of time, set to autoclose and check the error log for startup messages. But ultimately it's a case of put some monitoring in place and wait.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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