I was recently attempting to re-establish mirroring for a
client and realized the following waittype hanging on the database.
I initially thought, the mirroring session was not removed
correctly but after further verification it was soon obvious that the mirroring
session had been discontinued and it was clean.
When I attempt to kill the process PSID = 20 , I got the
following message
Spid = 20
Msg 6107,
Level 14, State 1, Line 1
Only user
processes can be killed.
At 2 am in the morning I was no mood for research , I was
just interested in getting the mirroring session established and get to bed.
I knew it was a matter of dropping the database and getting
about with the normal business. Then I mistakenly executed the restore
databases script !!!!. surprisingly the restore didn’t complain and progressed to
complete without errors and I continued to setup the mirroring session, which
completed successfully.
Later during the day I discovered that this could have
been an a idel/orphaned session that was left behind when mirroring was aborted.
Comments
Post a Comment