Friday, February 17, 2012

DBCC CHECKDB error

I am recieving the following error when I run the command

DBCC CHECKDB WITH NO_INFOMSGS

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.)

This does not seem like an error related to sql server. Does anybody know how to fix it so I can run the DBCC CHECKDB command?

Hi Gess,

This is prorbably network/tcpip issue. Get your networking guys to put a network trace to see if any packets are being dropped or if there any other problems on the network.

Is your server running Windows 2000?

cheers

Jag

No comments:

Post a Comment