Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL backup lock up the database access

Status
Not open for further replies.

santam2007

IS-IT--Management
Feb 20, 2007
18
HK
We found some Networker error events for SQL backup as below.

I think the below event will lock up the database access.
Is there any solution for such problem?

Subject: Operations Manager Critical Error Alert on mydomain\mydomain

Severity: Critical Error
Status: New
Source: SQL Server 2005 Service Availability
Name: SQL Server 2005 Block Analysis (MSSQLSERVER.BizTalkDTADb)
Description: The program "EMC NetWorker Module for Microsoft (R) SQL
Server" has been blocked for 2.8328 minutes on database BizTalkDTADb in
the SQL instance MSSQLSERVER. The defined acceptable blocking threshold
is 1 minute(s). "EMC NetWorker Module for Microsoft (R) SQL Server" is
running on SPID 56 as login NT AUTHORITY\SYSTEM and is blocked by SPID
59. The resource id is DB: 9 [BULKOP_BACKUP_DB]
.
Domain: mydomain
Agent: CISED199
Time: 26/03/2007 23:03:02

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top