How to Recover MS SQL Database from Suspect Mode || Solved 100%

In this video I have explained How to recover database from suspect mode

in sql server. This solution works from Sql Server 2008 to Sql Server 2016
Just Follow the following simple steps:

1: Just Copy the code given below,
2: Open Sql server,
3: Open New Query Window,
4: Paste the code in the New Query Window.
5: Replace your problematic database name
with the database_name in the code given below.
6: Execute the query,

You are done.

--==================================================
Sample Code to Execute in Sql Server:
--==================================================

EXEC sp_resetstatus database_name;
ALTER DATABASE database_name SET EMERGENCY
DBCC CHECKDB (database_name)
ALTER DATABASE database_name SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CHECKDB (database_name, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE database_name SET MULTI_USER

--==================================================

==================================================
Thanks for watching,
Please subscribe my channel.
==================================================
If you have any questions or queries, write them in comments below
or mail me at:
==================================================
Audio Used in Video:
The Coldest Shoulder
Credits: Youtube Free Music Library

[fredwolf]

This really saved my rear. Thank you very much.

[rajdipdebnath]

Thank you so much. Able to fix in a minute. Saved the DB and business.

[kudzaimasora]

Thanks for his saved a business from going burst without a backup

[atifameen]

Hi is there any chance after running this script
data in that was completely lost ?? if it was not successful

[itwaala]

Dear Sir, Can you please guide about connection string with ODBC method.