April 26, 2010 at 6:21 am
Executed as user: NT AUTHORITY\SYSTEM. Processed 9030728 pages for database 'databasename', file 'filename'on file 1. [SQLSTATE 01000] (Message 4035) Processed 74 pages for database 'databasename', file 'filename' on file 1. [SQLSTATE 01000] (Message 4035)
A nonrecoverable I/O error occurred on file ".bak:"
64(The specified network name is no longer available.). [SQLSTATE 42000] (Error 3271)
BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
This is the error i am getting please help asap
April 26, 2010 at 6:29 am
Are you taking backup to the local disk or SAN disks or on a network machine?
April 26, 2010 at 6:53 am
Hi i am taking backup to an network machine
April 26, 2010 at 7:07 am
You may have experienced a network issue during the backup. You really should configure your backups to be done to a local disk then copy it to a network resource.
April 26, 2010 at 7:35 am
Yep, I agree. Some time of network event, possibly a change in permissions? Hard to tell. Follow Lynn's advice.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 26, 2010 at 8:31 am
Third vote here. network copies can tolerate delays, and will retry if packets are lost (which happens all the time). The SQL backup throws pages out as fast as it can, and if there are too many delays, it abandons the backup.
Backup locally. Copy to the network.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply