Subject | Removing deadlocks via Backup/Restore. Any other way? |
---|---|
Author | PenWin |
Post date | 2009-05-04T10:38:14Z |
Hi!
I realize that I should fix my applications so that deadlocks don't
occur at all. Unfortunately, the occurence of deadlocks is so extremely
rare that I really have no hope of finding the cause. So instead I am
looking for a way to fix the effects. I know that a Backup/Restore cycle
removes my deadlocks. But - is there an alternative way that would not
require an exclusive access to the database?
Thanks, Pepak
I realize that I should fix my applications so that deadlocks don't
occur at all. Unfortunately, the occurence of deadlocks is so extremely
rare that I really have no hope of finding the cause. So instead I am
looking for a way to fix the effects. I know that a Backup/Restore cycle
removes my deadlocks. But - is there an alternative way that would not
require an exclusive access to the database?
Thanks, Pepak