We have a problem with one of our databases that has FileStream enabled. When we try to backup, we get the error
Backup failed because there is a mismatch in file metadata for file 65537
When we do a
DBCC, no errors get reported,
DBCC CHECKDB ('MyDB', repair_allow_data_loss) also does not return any issues. Users are not experiencing any issues when accessing the database, it is only the back-up that is a problem.
We have tried copying data to other tables, etc. but nothing has helped yet. We have even tried 3rd party repair tools but nothing has delivered results.
This is a very big database and creating a new DB and migrating the data is not really an option (will probably take many days).
Does anybody have any ideas on how to fix this issue or suggestions on what we can try?
I am now investigating undoing the FileStream...