Timeout error on large backups
neil@ascinternet.com
Posts: 6
I'm getting this error on my larger database backups (backup file size is in 10gig or larger):
(from SQL Backup Error Log file):SQL Backup log file
8/23/2007 2:01:00 AM: Backing up Billing (full database) to:
8/23/2007 2:01:00 AM: \\10.1.1.100\f$\MOBAC02\MOBAC02_Billing_FULL_200708230201.sqb
8/23/2007 2:01:00 AM: BACKUP DATABASE [Billing] TO DISK = '<AUTO>' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
8/23/2007 2:58:34 AM: Thread 0 error:
Error 620: Error writing to backup file(s).
Process terminated unexpectedly. Error code: -2139684860
8/23/2007 2:58:34 AM: Warning 210: Thread 0 warning:
Warning 210: Error writing to backup file: \\10.1.1.100\f$\MOBAC02\MOBAC02_Billing_FULL_200708230201.sqb
Warning: System error (The semaphore timeout period has expired)
SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally.
SQL error 3202: SQL error 3202: Write on 'SQLBACKUP_1EF54384-056C-4055-AF9D-B4CA3B2D89CF' failed, status = 112. See the SQL Server error log for more details."
SQL Backup Version 5.1.0.2781
SQL Server Version 8.00.2039
Server OS: Windows Server 2003 R2 Enterprise x64 Edition Service Pack 1
Hardware: IBM XSeries_460 3GHzx16 processors, 9727MB Ram
Backup destination is a SAN: \\10.1.1.100\f$\MOBAC02. There is no permission problem with the backup path.
All log file backups seem fine, and the smaller full database backups work. This problem appears with the largest full database backups.
Neil Roberts
Global Tel-Link
(from SQL Backup Error Log file):SQL Backup log file
8/23/2007 2:01:00 AM: Backing up Billing (full database) to:
8/23/2007 2:01:00 AM: \\10.1.1.100\f$\MOBAC02\MOBAC02_Billing_FULL_200708230201.sqb
8/23/2007 2:01:00 AM: BACKUP DATABASE [Billing] TO DISK = '<AUTO>' WITH NAME = '<AUTO>', DESCRIPTION = '<AUTO>', COMPRESSION = 1
8/23/2007 2:58:34 AM: Thread 0 error:
Error 620: Error writing to backup file(s).
Process terminated unexpectedly. Error code: -2139684860
8/23/2007 2:58:34 AM: Warning 210: Thread 0 warning:
Warning 210: Error writing to backup file: \\10.1.1.100\f$\MOBAC02\MOBAC02_Billing_FULL_200708230201.sqb
Warning: System error (The semaphore timeout period has expired)
SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally.
SQL error 3202: SQL error 3202: Write on 'SQLBACKUP_1EF54384-056C-4055-AF9D-B4CA3B2D89CF' failed, status = 112. See the SQL Server error log for more details."
SQL Backup Version 5.1.0.2781
SQL Server Version 8.00.2039
Server OS: Windows Server 2003 R2 Enterprise x64 Edition Service Pack 1
Hardware: IBM XSeries_460 3GHzx16 processors, 9727MB Ram
Backup destination is a SAN: \\10.1.1.100\f$\MOBAC02. There is no permission problem with the backup path.
All log file backups seem fine, and the smaller full database backups work. This problem appears with the largest full database backups.
Neil Roberts
Global Tel-Link
