April 7, 2011 at 5:06 am
We have table that is locked. I tried to kill all SPID which holds the same table. Unsuccessful. I tried to restart SQL Service (MS SQL Server 2008) - the table is locked again! After that we try to restart server, but table is still locked!!! What to do?
April 7, 2011 at 5:09 am
rollbacks of transactions.
check youre SQL server log if no info is there try tracing
April 7, 2011 at 5:13 am
How to roll back all transactions?
April 7, 2011 at 5:28 am
zblagojevic (4/7/2011)
How to roll back all transactions?
what i mean to say is that there is a possibility that by a restart SQL server is rolling back transactions which were not commited. Its something you dont need to do its something SQL will do for you. but it is visible in
youre sql log will be looking something like:
Message
31 transactions rolled forward in database 'DBAdatabase' (5). This is an informational message only. No user action is required.
April 7, 2011 at 8:54 am
Do not know your current architect, but I would disable anything that connects to the table under the hood(CDC, Replication, auditing) of that table has bitten me before when trying to debug.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply