Home Forums SQL Server 2005 T-SQL (SS2K5) Find out if a database is being used and how much RE: Find out if a database is being used and how much

  • James

    If you suspect the databases aren't being used at all, then run a Profiler trace against them for a week or a month or however long you need to. If you see no activity, set them to restricted user and leave them like that for the same period of time. If nobody squeals, take a final backup and remove the databases.

    John