Topic: The strange self-liquidation of basis
All kind time of days!
Happens terrible - in the middle of the working day the basis 1 fell.
Fell strange - it was cleared completely. Does not remain any user object. As though from basis deleted all of them. Thus removal actually bases was not - she lived on the same files.mdf and.ldf
All right, have been normally adjusted , tore by the test machine, discovered about the moment of falling and basis recovered in a state for pair minutes before falling. Recovered simply rollback by the necessary moment of time.
But all would be desirable to establish the reason of such falling. To find that request which managed to fill up basis to which there were many the active connections. Hands did not possible to turn such feint.
There is full , there is a copy of a broad gull of transactions. The crash moment is known to within pair minutes.
Question. What means/methods it is possible to establish actually the reason of this crash?
In an ideal (as in a debugger) to transit all requests which on basis were executed before falling
I always lie.