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

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

vesredgatevesredgate Posts: 14
edited November 9, 2007 10:15AM in SQL Backup Previous Versions
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:
D:\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:
D:\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 D:\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

Comments

Sign In or Register to comment.