What are the challenges you face when working across database platforms? Take the survey
Options

Timeout error when running the Backup

pdbapdba Posts: 4
edited November 25, 2015 9:33PM in SQL Backup Previous Versions
Hi Experts,

I am see the user is getting timeout error when database backup is running using SQL backup 7. Please suggest.

Sql backup version: SQL backup 7.70.18
SQL server version: Microsoft SQL Server 2008 R2 (SP3) - 10.50.6220.0 (X64) Mar 19 2015 12:32:14
Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

users are getting timeout error. and there is no high IO job runs this time except this backup using SQL backup 7. There high IO operation done by any other jobs.

Small DML's done by other jobs failing due this error when running in parallel with backup.
Error:
Time-out occurred while waiting for buffer latch type 2 for page (1:105), database ID 6. [SQLSTATE 42000] (Error 845)
Time-out occurred while waiting for buffer latch type 2 for page (1:219652), database ID 6. [SQLSTATE 42000] (Error 845).

Database size is approx 200+ GB.

Please suggest

Comments

  • Options
    peteypetey Posts: 2,358 New member
    Perhaps you can use Performance Monitor to monitor the SQL Server latches counters e.g. Average Latch Wait Time, Latch Waits/sec, and Number of Superlatches, just before the backup starts and slightly after the backup completes. It may show that the numbers were already high before the backup, and the backup just pushes them above the tolerable limits. It could also show if there are other processes that run during the backup that pushes the numbers up.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.