college
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;
college.txt · Last modified: 2020/08/10 02:35 by 127.0.0.1