Documentation on Setting Up Maintainer.exe

Mar 16, 2010 at 8:29 PM

Hello,
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)?

Editor
Mar 16, 2010 at 10:24 PM

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

http://sqlrbs.codeplex.com/Thread/View.aspx?ThreadId=204627

Let us know if you have specific questions on this.

- mike

Mar 17, 2010 at 5:07 PM

Thanks Mike.

Editor
Mar 20, 2010 at 12: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.

http://blogs.msdn.com/sqlrbs/archive/2010/03/19/running-rbs-maintainer.aspx

Thanks,

Pradeep.