Shutting down database due to exception 2905 during VLR processing at commit.

Question

Hello all, recently on an older SQL 2005 Cluster (on Windows 2003R2) we encountered the following event associated with a service restart:

Shutting down database due to exception 2905 during VLR processing at commit.

The service was restarted on the same node, no failover to the other node occurred.

Thoughts?

---

APR

Answer 1

Hi APR,

I think first you need to apply SQL Server 2005 Service Pack 4 to see if it would be work.

If you have any problem, please feel free to let me know.

TechNet Subscriber Support
If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Answer 2

Hi APR,

SQL Server Services tries to come online on the same node (3 times) prior to getting faileover to other node. With regard to exception that you received which brought SQL Service shut down, I think we need to read the logs (SQL Error Logs, Event Logs, Cluster Logs) and then find what happen.

---

Regards Gursethi Blog: http://gursethi.blogspot.com/ ++++ Please mark "Propose As Answer" if my answer helped ++++

Answer 3

Nothing other than that in the SQL logs, and all the event and cluster logs record is the service restart.  I will see if I can get approval to upgrade to SP4 as Maggie suggests.  Thanks all!

---

APR

Answer 4

That is most likely what we'll do, but I would still like to know what the error is actually indicating.  Oh well, more digging :)

Thanks!

---

APR

Answer 5

Hi APR ,

I’m writing to follow up with you on this post. Was the problem resolved?

If you are satisfied with our solution, I’d like to mark this issue as "Answered". Please also feel free to unmark the issue, with any new findings or concerns you may have.  

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.