Documentation on Setting Up Maintainer.exe

Mar 16, 2010 at 9:29 PM

Thanks for your help SQL RBS Team.  This week I've been actively developing based off your samples and I am able to add blobs into a file based store and reference that in an application database table and strarted going down the path of creating a FTP based file store but I have some questions along the way.  Today I got to the point to where data from the DB application tables is successfully deleted, however the blob data still remains on the store waiting for garbage collection. 

I wanted to know how I could set up Microsoft.Data.SqlRemoteBlobs.Maintainer.exe to use my application's connection string and run on a schedule (e.g. every 24 hours). 

Is there a paricular configuration file that I need to add this data to or is it passed in as a command line argument when setting up the task (to run with Windows Scheduler)?

Mar 16, 2010 at 11:24 PM

Rahul gives a good rundown of the process in the below thread:

Let us know if you have specific questions on this.

- mike

Mar 17, 2010 at 6:07 PM

Thanks Mike.

Mar 20, 2010 at 1:10 AM

Hi jgill,

I just published a blog post that gives more details and explanations around running maintainer. Please take a look and let me know if you have any questions.