10 Replies Latest reply on Oct 18, 2011 8:26 AM by Adam Bowen

    Snapshot Jobs Failing

    David Hawkes

      Getting this error when running a sanpshot against numerous Windows Servers


      com.microsoft.sqlserver.jdbc.SQLServerException: The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions.