Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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, 1,390 reads

Posted in DBA Philosophy on 10 August 2009