How to Fix SQL Server Databases in Suspect or Recovery Pending Mode

You may also like...

3 Responses

  1. Najih says:

    Thank you for this useful article.

  2. Mohamed Nasrullah says:

    Thanks. Worked like a charm.

  3. Husam says:

    Allow me to thank you for this nice article. I have the same problem and using filestream and I faced a problem in that I got this msg
    (Msg 5591, Level 16, State 5, Line 3 FILESTREAM feature is disabled.
    Msg 5105, Level 16, State 14, Line 3 A file activation error occurred. The physical file name ‘C:\Program Files\Microsoft SQL
    Server\MSSQL12.SQL2014ENT\MSSQL\DATA\DB_87459_newpayroll_filestream’ may be incorrect. Diagnose and correct additional errors, and retry the operation.
    Msg 945, Level 14, State 2, Line 3 Database ‘NewPayroll_20151213’ cannot be opened due to inaccessible files or insufficient memory or disk space.
    See the SQL Server errorlog for details.)
    Your advice please.

Leave a Reply

Your email address will not be published. Required fields are marked *

twelve − 11 =