User Tools

Site Tools


college

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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>​
college.txt ยท Last modified: 2020/08/10 02:35 (external edit)