In my current process, we have two production site SQL Servers 2014 (Sync), and one DR site SQL Server 2014 (ASync) in one WSFC.

I will be hosting 5-6 databases for AOAG set up, out of which one of the databases will be a filestream database.

Earlier (SQL Server 2008 R2) we used to run a log backup followed by a checkpoint using a log shipping backup job to speed up the filestream garbage collection process.

Now because I will add a filestream database to AOAG (SQL Server 2014), how should I run log backup and checkpoint?

Will sp_filestream_force_garbage_collection alone help?

I am getting:

failed to access the garbage collection table. Event ID 5571

I have referenced Sql FILESTREAM garbage collection issue, so I am stuck up with it and working on various possibilities to clear the issue.

  • I'm not sure what you mean by "speed up"? Nothing will make the GC happen faster or slower as a process... or do you mean calling the GC more often rather than just after checkpoints? – Sean Gallardy - Retired User May 18 '16 at 21:26
  • What is the error preceding the 5571? Are there are before it? Normally 5571 is a victim of something else. Also, what is the state of 5571? – Sean Gallardy - Retired User May 20 '16 at 13:56
  • Hi Sean Sir, we are planning to change the recovery model of Filestream database to simple recovery model and run a CHECKPOINT to speed up File Stream Garbage Collection.But problem is we will miss out on LSN break and Log shipping breaks.So is there any way I can go ahead and change the recovery model to simple and log shipping doesnot break (As I am aware there is no way if we change it to simple RM).Please let me know if any other way ? Thank you sir – SQLBoy May 23 '16 at 15:15
  • nope. You also didn't add any information form the above comments I asked. – Sean Gallardy - Retired User May 23 '16 at 18:02
  • 1
    My advice would be to open up a support ticket with Microsoft. – Sean Gallardy - Retired User May 24 '16 at 2:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.