Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Filestream - Clean up unwanted files Expand / Collapse
Author
Message
Posted Friday, March 26, 2010 8:40 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Sunday, March 23, 2014 11:46 AM
Points: 87, Visits: 155
I have been testing an SSIS application that, amoung other things, stores report files as FILESTREAM data. I've got about 12,000 files in many folders under the default FS folder on my C drive and would like to get rid of them. I tried deleting all of the rows from a table then issuing a CHECKPOINT and also truncating a table and issuing a CHECKPOINT command but neither approach eliminated any of the blobs stored in the FS folder.
Post #890690
Posted Thursday, December 16, 2010 8:29 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 24, 2014 6:45 AM
Points: 563, Visits: 1,000
Im struggling with the same thing right now... any answers? Delete from table, does not delete physical file. Update of record creates an additional file........ and no clean up (as yet).

Also if you look at a record in a table, how to you link that record and the file stored??
Post #1035881
Posted Thursday, December 16, 2010 8:40 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 24, 2014 6:45 AM
Points: 563, Visits: 1,000
Ok, found out about the garbage collector taking some time to complete the deletes, etc

Still looking for the "link" between the record and the physical file?
Post #1035890
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse