Subscribe to this blog
Archives: August 2009
Journey to trouble-shoot Error 5042 (cannot remove a file xxx because it is not empty)
I was working on a table partition management task yesterday. The table is partitioned on a datetime column, and each partition has one and only one dedicated filegroup, and each filegroup is dedicated to one and only one partition and contains only one file in the filegroup.
After I cleaned… Read more
3 comments, 610 reads
Posted in DBA Philosophy on 10 August 2009