This shows you the differences between two versions of the page.
— |
college [2020/08/10 02:35] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== 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. | ||
+ | <code> | ||
+ | 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; | ||
+ | </code> |