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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 DBCC CHECKDB Fails

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 0
A 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.
Go to Top of Page

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?
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -