SR - Error Database(Suspect)

--SR - Error Database(Suspect)

EXEC SP_RESETSTATUS  softrestaurant95pro;

ALTER DATABASE softrestaurant95pro SET EMERGENCY;

DBCC CHECKDB (softrestaurant95pro);

ALTER DATABASE softrestaurant95pro SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

DBCC CHECKDB (softrestaurant95pro, REPAIR_ALLOW_DATA_LOSS);

ALTER DATABASE softrestaurant95pro SET MULTI_USER;