Sunday, March 25, 2012

Deleting FileGroup/(.ldf) file

Hello, I'm currently busy with Table Partitioning. I have 9 FileGroups, which is all populated with data.

My question is, how do you delete / trucate a FileGroup / file(.ldf) which is already populated?

I tried

ALTER DATABASE ##

but it keeps telling me that the FileGroup cannot be deleted because it is populated.

Any answers would be greatly appreciated.

You have filegroups for the log files?

No comments:

Post a Comment