One of my SQL Servers (SQL 2000 SP4) is reporting this error in the Maintenance Plan. But shortly after it shows this error is does successfully backup my Databases (per log history), however the plan is indicating "failure".
I have no idea how to resolve this nor why it is happening.
Rob.
Hi,
it seems, that an t-sql statement is blocking.
Use the profiler and filter by object name = sp_prepexec and SPID.
actual in the KB:
HOW TO: Troubleshoot Application Performance Issues
How to monitor SQL Server 2000 blocking
tosc
No comments:
Post a Comment