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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy