thanks for the info... I have not done that yet, because what i am running now is just a dbcc shrinkdatabase (database, 20)... I saw an issue on Microsoft site...

thanks for the post, not really sure how to find the file number though, or what a manual checkpoint is either, can you expand on that a little?  sorry as...

still no ideas?

no ideas???

sorry... its SQL server 2000 service pack 4, and there is a ton of space to do the work too. just about double the space...

yes I understand, I just thought that there might be somone on that knew the answer.

Cool thanks! Thats what i was thinking, but I just wanted to make sure...

Wow no one knows???

ohh yeah this is for 2000 sorry... anyone know if the items in the maintenance plans will make the database un-accessable?