Database entered "Suspect" mode and I was unable to recover on RDS

Thank you for reaching out.

The database state changes to ‘suspect’ mode when database recovery process has initiated but not finished successfully, requiring users to fix that issue and repair the corrupted files. It further implies that the database is not available for user access: you are unable to connect to the database or recover it during the server startup.

In general, there may be multiple general causes for database going into suspect state. Some of them includes,

• Database files could have been corrupted.
• There is not enough space available for the SQL Server to recover the database during startup.
• Database cannot be opened due to inaccessible files or insufficient memory or disk space.
• Database files are being held by operating system, third party backup software etc.
• Unexpected SQL Server Shutdown, Power failure or a Hardware failure
• There may be issues while rolling back or completing a transaction.
• The device or drive is inaccessible to the server where the server log files are kept due to hardware issues in storage devices.

To answer your question, we require details that are non-public information. Please open a support case with AWS using the following link.

That being said, please do accept answers if the answers resolve your question. That's a best practice in Q&A communities both for other viewers and also out of respect to other's time spent answering the questions.

As always, Happy Cloud Computing.

Hi, My team faced the same issue, we could recover all data but with the help of AWS support team. We opened a ticket with them because the only way to recover everything is by executing some troubleshooting with sysadmin privileges and this is managed by them. We waited like 3 hours, but thankfully everything went just fine.