A side note with transaction management as far as begin tran/commit/rollback go. I am sure you will find this in the best practices artice, but you can use a raiserror and/or a...
I assume you have ran DBCC's and there is no corruption? This would appear at a first glance to be a disk sub-system problem. I would start by checking the...