How to Recover Suspect or Recovery Pending Databases in SQL Server - SQL Server DBA Tutorial

In this video you will learn how to recover suspect or recovery pending databases using SQL Server Management studio, it illustrates how to find the reason why SQL Server database went in suspect or recovery pending state, how to resolve File related issues. How to find why SQL Server database went in suspect mode using DBCC commands, also talk about last options to restore database incase it is corrupted and can't be brought online using normal ways.

Script used in the video

Select name,state_desc from sys.databases

--Run this command to check what exactly is the issue for database being recovery/suspect
DBCC CHECKDB(Demo) WITH NO_INFOMSGS



Recover Suspect or Recovery Pending Databases in SQL Server - SQL Server DBA Tutorial