SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 DBCC CHECKDB Fails
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

pete20
Starting Member

2 Posts

Posted - 04/14/2013 :  03:50:30  Show Profile  Reply with Quote
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 - 04/14/2013 :  04:03:30  Show Profile  Reply with Quote
Just to add that on the first attempt the sql service crashes also.
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 04/15/2013 :  13:31:48  Show Profile  Visit russell's Homepage  Reply with Quote
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

USA
798 Posts

Posted - 04/15/2013 :  13:32:32  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000