October 31, 2008 at 11:03 am
I am trying to see which databases been used and which are not, I am trying to clean the server. Any ideas how I can do that?Thank you
October 31, 2008 at 2:39 pm
Either use third party tool like SQL diagnostic manager or else you can run profiler for a week on those particular databases and collect data into a table. If nothing is happening on those databases, profiler would keep running but will not collect data and won't be space issue.
SQL DBA.
October 31, 2008 at 5:37 pm
I would do very simple test... go and check the .mdf and .ldf files on the operating System. Check for Date modified. Thats when these databases were used ( insert/update/delete statements were ran), running a select statement will not change modified date...
Hope this helps,
Imran Mohammed.
November 1, 2008 at 7:41 am
Take offline and see if anyone complains 🙂
November 2, 2008 at 7:49 am
I favor the offline approach, but you're likely to upset some people. Instead, if you suspect something isn't being touched, set it to autoclose. It will close, but more importantly, it will mark a record in the error log. If someone accesses it, there's a slight delay as it's opened and a log record it written.
These can sit there, and if you don't see the open message in the log after a few months, I'd back them up, save the tape, and delete them.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply