Post reply

How to get unused databases

  • February 3, 2010 at 5:28 am

    #144750

    I've a sql server 2000 with approximately 60 databases and I have to migrate this databases to sql server 2005. But not all this db's are being used. I guess just 20 or less are being used. My job is migrate just active the database. So, my question is: Is there a way to discover if the database are being used? If is there any table system where I can get this information...

    Thanks in advance!

    Rafael Melo

    (Brazil)

  • February 3, 2010 at 6:10 am

    #1112793

    Think you will have to turn on profiler for a while and trace logins to see who is using it. You may also be able to trawl through the tables in each database and look for datetime fields - you might be able to see when it was last used by looking at the data.

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

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