Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql2020
Yak Posting Veteran
54 Posts |
 Posted - 2011-06-15 : 23:04:40
|
| HI DBCC Check DB throws below error :A severe error occurred on the current command. The results, if any, should be discarded.How to reolve this please help me..sql2020 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-06-16 : 01:35:56
|
| Firstly, go into your SQL error Log - are the results in there?Secondly, run DBCC CHECKDB with WITH ALL_ERRORMSGS , does this solve your problem?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
sql2020
Yak Posting Veteran
54 Posts |
Posted - 2011-06-16 : 03:23:29
|
| Hi Run DBCC cmd here the result:Msg 0, Level 11, State 0, Line 0A severe error occurred on the current command. The results, if any, should be discarded.here the error log :2011-06-16 00:18:01.92 spid71 DBCC encountered a page with an LSN greater than the current end of log LSN (64568:0:1) for its internal database snapshot. Could not read page (11831:858861107), database 'test' (database ID 10), LSN = (909258551:691222840:2573), type = 98, isInSparseFile = 1. Please re-run this DBCC command.2011-06-16 00:18:01.92 spid71 DBCC encountered a page with an LSN greater than the current end of log LSN (64568:0:1) for its internal database snapshot. Could not read page (13877:976367881), database 'test' (database ID 10), LSN = (1867254066:879518051:22318), type = 108, isInSparseFile = 1. Please re-run this DBCC command.2011-06-16 00:18:01.92 spid71 DBCC encountered a page with an LSN greater than the current end of log LSN (64568:0:1) for its internal database snapshot. Could not read page (12592:1647718705), database 'test' (database ID 10), LSN = (1563457584:892406285:12333), type = 32, isInSparseFile = 1. Please re-run this DBCC command.2011-06-16 00:18:01.92 spid71 DBCC encountered a page with an LSN greater than the current end of log LSN (64568:0:1) for its internal database snapshot. Could not read page (11833:858667314), database 'test' (database ID 10), LSN = (858992942:842412335:25120), type = 32, isInSparseFile = 1. Please re-run this DBCC command.2011-06-16 00:18:03.47 spid71 DBCC CHECKDB (test) WITH no_infomsgs executed by testuser terminated abnormally due to error state 1. Elapsed time: 0 hours 1 minutes 5 seconds.please let me know how to trouble shoot thissql2020 |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-06-16 : 05:33:53
|
| Restore from last good backup.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
|
|
DBCC Check db Error ..