cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Veritas.com
Support

SQL Database Dealocks

rob_ramos
Level 3

‎12-05-2005 01:16 AM

Hi all

Currently Running EV 5 SP 5 on Server 2003. After Running a archive I receive errors stating that there is a SQL Deadlock occurring in the database. I have tried testing the system (in a lab environment) by running a scheduled run and then a "Run Now" archive but I am not getting the error from that. Has anyone received this sort of error before and if so how did they resolve the issue?

Regard

Robert Ramos
0 Kudos
2 REPLIES 2

Aaron_Mears
Level 4
Employee Accredited Certified

‎12-05-2005 08:07 AM

If you run in report mode do you get any progress in archiving...or any consistent roadblocks
0 Kudos

Jason_Bunn
Level 3

‎12-07-2005 11:52 AM

We get deadlocks every once and a while as well. By any chance are you doing any SQL replication? We thought this may have something to do with it or at least causing more deadlocks. We are trying replication even though I am not sure it is supported for EV databases. For sure do not do replication on the Compliance or Discovery DBs. I have had problems with Compliance and Discovery upgrades if their DBs are setup for SQL replication.

Unfortunately, I don't have a great answer. This link helps describe deadlocks it is possible that it is the application.

http://www.sql-server-performance.com/deadlocks.asp
0 Kudos