My backups are failing if UNC is used for the backup file name even on the local server:
EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE [Database] TO DISK = [D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\<AUTO>] WITH COMPRESSION = 3, INIT, KEYSIZE = 256, VERIFY, MAILTO_ONERROR = [
user@co.com], PASSWORD = [password]"'
SQL Backup v5.2.0.2825
Backing up Database (full database) to:
\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Database_FULL_MyServer_20071108_113918.sqb
Database size : 148.500 MB
Compressed data size: 10.869 MB
Compression rate : 92.68%
Processed 5064 pages for database 'Database', file 'Database_data' on file 1.
Processed 1 pages for database 'Database', file 'Database_log' on file 1.
BACKUP DATABASE successfully processed 5065 pages in 1.133 seconds (36.621 MB/sec).
Validating files:
\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Database_FULL_MyServer_20071108_113918.sqb
The backup set on file 1 is valid.
SQL Backup process ended.
(18 row(s) affected)
name value
exitcode 0
sqlerrorcode 0
filename001
\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Database_FULL_MyServer_20071108_113918.sqb
(3 row(s) affected)
EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE [Database] TO DISK = [\\MyServer\D$\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\<AUTO>] WITH COMPRESSION = 3, INIT, KEYSIZE = 256, VERIFY, MAILTO_ONERROR = [
user@co.com], PASSWORD = [password]"'
SQL Backup v5.2.0.2825
Backing up Database (full database) to:
\\MyServer\D$\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Database_FULL_MyServer_20071108_113959.sqb
Thread 0 error:
Error 620: Error writing to backup file(s).
Process terminated unexpectedly. Error code: -2139684860
Warning 210: Thread 0 warning:
Warning 210: Error writing to backup file: \\MyServer\D$\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Database_FULL_MyServer_20071108_113959.sqb
Warning: System error 1450 (Insufficient system resources exist to complete the requested service)
SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally.
SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_6848A437-B251-4FB0-A344-179527D22A6F:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
SQL error 3202: SQL error 3202: Write on "SQLBACKUP_6848A437-B251-4FB0-A344-179527D22A6F" failed: 1117(The request could not be performed because of an I/O device error.)
SQL Backup exit code: 790
SQL error code: 3202
(16 row(s) affected)
name value
exitcode 790
sqlerrorcode 3202
filename001 \\MyServer\D$\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Database_FULL_MyServer_20071108_113959.sqb
(3 row(s) affected)
EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE [Database] TO DISK = [\\MyServer\Backup\<AUTO>] WITH COMPRESSION = 3, INIT, KEYSIZE = 256, VERIFY, MAILTO_ONERROR = [
user@co.com], PASSWORD = [password]"'
SQL Backup v5.2.0.2825
Backing up Database (full database) to:
\\MyServer\Backup\Database_FULL_MyServer_20071108_114016.sqb
Thread 0 error:
Error 620: Error writing to backup file(s).
Process terminated unexpectedly. Error code: -2139684860
Warning 210: Thread 0 warning:
Warning 210: Error writing to backup file: \\MyServer\Backup\Database_FULL_MyServer_20071108_114016.sqb
Warning: System error 1450 (Insufficient system resources exist to complete the requested service)
SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally.
SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_627C338A-0511-4D73-9B54-1F2036DE0703:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
SQL error 3202: SQL error 3202: Write on "SQLBACKUP_627C338A-0511-4D73-9B54-1F2036DE0703" failed: 1117(The request could not be performed because of an I/O device error.)
SQL Backup exit code: 790
SQL error code: 3202
(16 row(s) affected)
name value
exitcode 790
sqlerrorcode 3202
filename001 \\MyServer\Backup\Database_FULL_MyServer_20071108_114016.sqb
(3 row(s) affected)
Any help?
Thanks
The key part of the log is the following, which is a Windows error:
EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE [Database] TO DISK = [D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\<AUTO>] WITH COMPRESSION = 3, INIT, KEYSIZE = 256, VERIFY, MAILTO_ONERROR = [user@co.com], PASSWORD = [password]"'
SQL Backup v5.2.0.2825
Backing up Database (full database) to:
Database size : 148.500 MB
Compressed data size: 10.869 MB
Compression rate : 92.68%
Processed 5064 pages for database 'Database', file 'Database_data' on file 1.
Processed 1 pages for database 'Database', file 'Database_log' on file 1.
BACKUP DATABASE successfully processed 5065 pages in 1.133 seconds (36.621 MB/sec).
Validating files:
The backup set on file 1 is valid.
SQL Backup process ended.
(18 row(s) affected)
name value
exitcode 0
sqlerrorcode 0
filename001
(3 row(s) affected)
EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE [Database] TO DISK = [\\MyServer\D$\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\<AUTO>] WITH COMPRESSION = 3, INIT, KEYSIZE = 256, VERIFY, MAILTO_ONERROR = [user@co.com], PASSWORD = [password]"'
SQL Backup v5.2.0.2825
Backing up Database (full database) to:
\\MyServer\D$\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Database_FULL_MyServer_20071108_113959.sqb
Thread 0 error:
Error 620: Error writing to backup file(s).
Process terminated unexpectedly. Error code: -2139684860
Warning 210: Thread 0 warning:
Warning 210: Error writing to backup file: \\MyServer\D$\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Database_FULL_MyServer_20071108_113959.sqb
Warning: System error 1450 (Insufficient system resources exist to complete the requested service)
SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally.
SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_6848A437-B251-4FB0-A344-179527D22A6F:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
SQL error 3202: SQL error 3202: Write on "SQLBACKUP_6848A437-B251-4FB0-A344-179527D22A6F" failed: 1117(The request could not be performed because of an I/O device error.)
SQL Backup exit code: 790
SQL error code: 3202
(16 row(s) affected)
name value
exitcode 790
sqlerrorcode 3202
filename001 \\MyServer\D$\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Database_FULL_MyServer_20071108_113959.sqb
(3 row(s) affected)
EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE [Database] TO DISK = [\\MyServer\Backup\<AUTO>] WITH COMPRESSION = 3, INIT, KEYSIZE = 256, VERIFY, MAILTO_ONERROR = [user@co.com], PASSWORD = [password]"'
SQL Backup v5.2.0.2825
Backing up Database (full database) to:
\\MyServer\Backup\Database_FULL_MyServer_20071108_114016.sqb
Thread 0 error:
Error 620: Error writing to backup file(s).
Process terminated unexpectedly. Error code: -2139684860
Warning 210: Thread 0 warning:
Warning 210: Error writing to backup file: \\MyServer\Backup\Database_FULL_MyServer_20071108_114016.sqb
Warning: System error 1450 (Insufficient system resources exist to complete the requested service)
SQL error 3013: SQL error 3013: BACKUP DATABASE is terminating abnormally.
SQL error 3271: SQL error 3271: A nonrecoverable I/O error occurred on file "SQLBACKUP_627C338A-0511-4D73-9B54-1F2036DE0703:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).
SQL error 3202: SQL error 3202: Write on "SQLBACKUP_627C338A-0511-4D73-9B54-1F2036DE0703" failed: 1117(The request could not be performed because of an I/O device error.)
SQL Backup exit code: 790
SQL error code: 3202
(16 row(s) affected)
name value
exitcode 790
sqlerrorcode 3202
filename001 \\MyServer\Backup\Database_FULL_MyServer_20071108_114016.sqb
(3 row(s) affected)
Any help?
Thanks