Tips, Expertise, Articles and Advice from the Pro's for Your Website or Blog to Succeed
This post will explain why a database (DB) is tagged as a recovery pending. It will also discuss how to resolve the ‘SQL server database in recovery pending status' issue. You may fix the issue by running queries in SQL Server Management Studio (SSMS) or by utilizing a professional SQL database recovery tool.
SQL Server Database States
Besides storing table-based data in SQL Server, you can also store Binary Large Object (BLOB) data as files using the SQL Server FILESTREAM feature. This feature allows the storing of the varbinary(max) objects onto the file system instead of placing them inside a database. However, you can create a database with a 'FILESTREAM' filegroup, allowing you to perform actions on the data stored in the file system using the database.
Sometimes, when saving files to a database using FILESTREAM in SQL Server, the files may turn corrupt. Also, modifying or deleting the files placed in the file system folder (as FILESTREAM data container) may result in consistency errors reported by DBCC CHECKDB. To fix the errors, you can try restoring the database to its original state. But if the backup is not available, repairing the FILESTREAM database using the DBCC CHECKDB command with the REPAIR_ALLOW_DATA_LOSS option may help.