college
Differences
This shows you the differences between two versions of the page.
|
college [2019/04/03 13:56] k2patel created |
college [2020/08/10 02:35] |
||
|---|---|---|---|
| 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)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
