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
Next revision Both sides next revision
start [2019/04/03 13:55]
k2patel [CPanel]
start [2019/04/03 13:55]
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: 2023/09/15 20:33 by k2patel