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?
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.