College

AdventureWorks2016CTP3 (suspect)

During my course after importing database every time my laptop goes to sleep. So following set of command restore the working database.

EXEC sp_resetstatus AdventureWorks2016CTP3;
ALTER DATABASE AdventureWorks2016CTP3 SET EMERGENCY;
DBCC checkdb(AdventureWorks2016CTP3);
ALTER DATABASE AdventureWorks2016CTP3 SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DBCC CheckDB (AdventureWorks2016CTP3, REPAIR_ALLOW_DATA_LOSS);
ALTER DATABASE AdventureWorks2016CTP3 SET MULTI_USER;