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