Backup is failing when UNC is used for the backup file name.

vesredgate

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

Jason Cook

The key part of the log is the following, which is a Windows error:
"Warning: System error 1450 (Insufficient system resources exist to complete the requested service) "

The following link refers to a similar scenario that exists with Windows-based backup software, so might be of some use:
http://support.microsoft.com/default.as ... -us;304101

Hope that helps,
Jason