November 14, 2007 at 8:34 am
I suspect that many SQL Server databases are unused and would like to identify ones that have not had any user connections to them in say a month. This would be helpful for archiving any old unused dbs. Does any one know the best way of achieving this?
November 14, 2007 at 9:21 am
The way I did it was to run profiler from my PC monitoring only the databases I thought were not in use to see if anyone was using them.
November 14, 2007 at 9:37 am
When I took over in one place as DBA, I convinced him to let me put any db in question in a read only status. Although that generated a couple of quick help tickets, most weren't in use, and we left those in a read only mode and archived them at a later date.
That may not be possible in all enviroments but sometimes a radical solution is needed. It isn't hard in any case to put the db back in a normal status.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply