User Tools

Site Tools


start

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
start [2019/04/03 09:55]
k2patel [CPanel]
start [2019/04/03 09:55] (current)
k2patel [College]
Line 167: Line 167:
   * [[http://​www.cpanel.net/​documentation/​easyapache/​ | easyapache ]]   * [[http://​www.cpanel.net/​documentation/​easyapache/​ | easyapache ]]
  
-==== 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. +
-<​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>​+
 ===== Windows ===== ===== Windows =====
   - [[ http://​bugs.php.net/​bugs-generating-backtrace-win32.php | Microsoft Debug Diagnostic Tools ]]   - [[ http://​bugs.php.net/​bugs-generating-backtrace-win32.php | Microsoft Debug Diagnostic Tools ]]
start.txt · Last modified: 2019/04/03 09:55 by k2patel