SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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, 8,208 reads

Posted in DBA Philosophy on 10 August 2009