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 |
|
pete20
Starting Member
2 Posts |
 Posted - 2013-04-14 : 03:50:30
|
| Hi,We are running DBCC CHECKDB WITH ALL_ERRORMSGS.After couple of minutes the execution fails and we get the following error:Msg 64, Level 20, State 0, Line 0A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)We then retry executing the same command again. In the second attempt the command executes successfully.Why is it failing on the first attempt? |
|
|
pete20
Starting Member
2 Posts |
Posted - 2013-04-14 : 04:03:30
|
| Just to add that on the first attempt the sql service crashes also. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-04-15 : 13:31:48
|
| If the sqlserver service is crashing then all connections will fail, thus your checkdb fails.Need to look into what/why the service is stopping. What do you see in the event logs? |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2013-04-15 : 13:32:32
|
| Something is causing SQL to crash - you need to investigate why that is happening. The error message you are getting indicates that the connection from your client to the server is being interrupted - most likely due to the service crashing.There should be some indication of why SQL Server crashed in the windows event logs. |
|
|
|
|
|
|
DBCC CHECKDB Fails