when my database last used

• DKG-967908

  SSCrazy

  Points: 2345

  More actions

  October 25, 2014 at 10:48 am

  #294563

  Hi Friends,

  Being a DBA this sounds to be very basic requirement but i am not able to figure it out.

  Actually I have 80+ dbs on a server to so my client asked me to check which database when last used. so that we can clean up/get rid off the unused dbs.

  I checked on several forums and sites but not able to find any appropriate solution. i got some scripts but it works on the basis if the db have indexes else it doesn't work and in some of the cases it's giving null value.

  So it not giving any authentic value in my case.

  Another important point is last vendor provided the same report to my client in past so it means its possible somehow.

  If someone have experience on it and know any authentic way or any third party tool - please let me know.

  Thanks in advance.

  Cheers!