We have an EDM in our c# app, and we use FileStream/FileTable technology to store documents (Word, PDF, etc.). We have a database with only 2 filetable tables to make the job. (other data are stored in a second classical db).
One of our db in production was in "Recovery pending status" today, we see a lot of reasons and workaround to fix it.
For this time, we need to detach an reattach it, but it is not satisfactory for us, we want to know why and avoid this issue.
For information and for different reasons, our application needs to open an Office doc (word / excel) from c# and we use the Filetable share directory like \\serveur\instance\FS for that.
A strong constraint is that the user can open the document and save it transparently.
Our questions are:
1. At the moment where the db is in "Recovery pending status", are there any tools or SQL statement to help us to understand the reason?
2. Is there a daily check to be done regularly on the databases to prevent these issues?
3. Of course, this db contains about 50GB to 300GB and important documents, is there a risk of losing the data?
4. What are the usual tools to repair, for example: if we detach the db and we cannot reattach it, what to do?
Thanks a lot for your Help.
With kind regards