1

Topic: From both ends of the channel there are processes

Kind day, the problem following, is sql the server 2008 r2, on it of basis 1. The server on the virtual machine, recovered  and problems began bases, the majority solved, but one basis is not accessible...
At an input swears:
The session is completed by the manager.
For the reason:
Connection with the server of databases is broken off by the manager
Microsoft SQL Server Native Client 11.0: Supplier TCP: the Distant host forcedly broke off existing connection.
HRESULT=80004005, HRESULT=80004005, HRESULT=80004005, HRESULT=80004005, HRESULT=80004005, HRESULT=80004005, HRESULT=80004005, SQLSrvr: SQLSTATE=08S01, state=1, Severity=10, native=10054, line=0
SQLSrvr: SQLSTATE=08S01, state=1, Severity=10, native=10054, line=0
SQLSrvr: SQLSTATE=08S01, state=1, Severity=10, native=10054, line=0
Made:
ALTER DATABASE <a DB Name> SET EMERGENCY
ALTER DATABASE <a DB Name> SET SINGLE_USER
DBCC CHECKDB (<a DB Name>, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE <a DB Name> SET MULTI_USER
Did not help:
The message of 9675 component Service Broker, state 1: It is analyzed types of messages: 14.
The message of 9676 component Service Broker, state 1: It is analyzed service contracts: 6.
The message of 9667 component Service Broker, state 1: It is analyzed services: 3.
The message of 9668 component Service Broker, state 1: It is analyzed queues of services: 3.
The message of 9669 component Service Broker, state 1: It is analyzed dialogue finishing points: 0.
The message of 9674 component Service Broker, state 1: It is analyzed groups of messages: 0.
The message of 9670 component Service Broker, state 1: It is analyzed bindings of remote service: 0.
The message of 9605 component Service Broker, state 1: It is analyzed dialogue priorities: 0.
The message 8939, level 16, state 98, line 3
Table error: the identifier of object 0, the index identifier-1, section 0 identifier, the identifier of unit of layout-9020373361737924608 (type Unknown), page (3372:2100441395). The test (IS_OFF (BUF_IOERR, pBUF-> bstat)) did not transit. Values - 12584969 and-14.
For correction of the given error it is necessary to rectify other errors at first.
The message 8939, level 16, state 98, line 3
Table error: the identifier of object 0, the index identifier-1, section 0 identifier, the identifier of unit of layout-8371861316339892224 (type Unknown), page (13616:942815280). The test (IS_OFF (BUF_IOERR, pBUF-> bstat)) did not transit. Values - 12584969 and-1.
For correction of the given error it is necessary to rectify other errors at first.
And further in the same style...
Made  SQL, transferred on other server (2012 sql and 2012 express)
There an error another:
The session is completed by the manager.
For the reason:
Connection with the server of databases is broken off by the manager
Microsoft SQL Server Native Client 11.0: the Supplier of the general storage: From both ends of the channel there are processes.
HRESULT=80004005, HRESULT=80004005, HRESULT=80004005, HRESULT=80004005, HRESULT=80004005, HRESULT=80004005, HRESULT=80004005, SQLSrvr: SQLSTATE=08S01, state=1, Severity=10, native=233, line=0
SQLSrvr: SQLSTATE=08S01, state=1, Severity=10, native=233, line=0
SQLSrvr: SQLSTATE=08S01, state=1, Severity=10, native=233, line=0
Volume of packets increased to a maximum... Did not help.
Prompt in what a problem and basis it is live basically?

2

Re: From both ends of the channel there are processes

Cancell wrote:

a table Error: the identifier of object 0, the index identifier-1, section 0 identifier, the identifier of unit of layout-9020373361737924608 (type Unknown), page (3372:2100441395). The test (IS_OFF (BUF_IOERR, pBUF-> bstat)) did not transit. Values - 12584969 and-14.
For correction of the given error it is necessary to rectify other errors at first.

dbcc checktable since the very first in errors
Well and here at it look

3

Re: From both ends of the channel there are processes

Cancell;
the beaten.

4

Re: From both ends of the channel there are processes

Vladislav Kolosov;
It can be recovered somehow? Since it became from already problem basis, or it is possible to repair basis?

5

Re: From both ends of the channel there are processes

Cancell;
I do not know methods. Try to create  once again on a local disk from working basis, then copy.

6

Re: From both ends of the channel there are processes

As a result not corrected tables it was necessary , to a configurator got, made  and preempted in the file. There already handling collected the data where is and pushed where they were deleted... Like while it turns out to recover.
All thanks!