203 reputation
17
bio website obligatorymoniker.wordpress.c…
location
age
visits member for 1 year, 9 months
seen Aug 30 at 13:59

Jul
3
awarded  Popular Question
Jun
12
awarded  Yearling
Sep
25
comment How can I find and clean up unused database files?
@JonSeigel Gocha didn't understand what you meant. I think we may differ in philosophy of how these things should be handled. My take is that when I fix or clean up something it is not really fixed until the system itself will ensure that it stays in the fixed state indefinitely or alerts me when it is no longer fixed. I may not get this email for a year or more but I want to have it check every week because I want this completely out of my head and I want to know that if it ever happens again my system will tell me (push) and I don't have to check (pull).
Sep
23
comment How can I find and clean up unused database files?
@JonSeigel The solution I have posted below will find all database files in all directories on all drives attached to the SQL server. It also emails you only when there are things to be addressed. Your solution is definitely the start of something similar in TSQL but I don't believe it would be fair to directly compare them at this point, unless you want to expand on your solution, which would be awesome as having the option to do this with TSQL would be something I am sure others might want.
Sep
23
comment How can I find and clean up unused database files?
@JonSeigel I use this in production. It does not delete any files but simply alerts me to their presence so that I can either exclude them because they are legitimate or clean them up if I don't want them. Either way it gives me the information I need to make the decision instead of it just being forgotten about.
Sep
21
asked How can I find and clean up unused database files?
Sep
21
answered How can I find and clean up unused database files?
Sep
21
awarded  Informed
Feb
19
awarded  Scholar
Feb
19
accepted Performance benefit of taking unused databases offline
Dec
13
awarded  Supporter
Dec
13
awarded  Revival
Dec
13
awarded  Student
Dec
13
awarded  Teacher
Dec
13
asked Performance benefit of taking unused databases offline
Dec
13
answered Database starts always in recovery mode