Database in Suspect mode
As a DBA one of the main responsibilities is to make sure that Database on the server is fully accessible at all times. There some occasions however, when the DB is in SUSPECT mode! In this article I'll walk you through how to resolve this issue
INTRODUCTION
There might be few reasons why the DB is in SUSPECT mode.
1. Database file or transaction log file got corrupted or damaged
2. During a transactions Sql server services stopped or restarted unexpectedly
3. There might be an issue with the transaction log space where logs have no space to grow
4. Hardware failure
Pellentesque semper orci enim, at dapibus arcu fringilla vitae. Praesent sit amet consequat lorem. Sed elit odio, aliquet eget elementum sit amet, sodales ut massa. Phasellus eget velit facilisis, viverra urna id, finibus est. Pellentesque convallis et elit a faucibus. Suspendisse luctus mollis porta. Morbi hendrerit ex turpis, sed consectetur nunc lacinia nec. Praesent vitae viverra tellus, a pretium velit.