July 27, 2011 at 10:47 pm
Hello All,
Last few days, Im facing an issue while taking backups to the network path \\xxxxx\mm.bak
The back up is failing due to below error
100 percent processed.
Processed 3 pages for database 'XXXX', file 'xx' on file 1.
Msg 3271, Level 16, State 1, Line 1
A nonrecoverable I/O error occurred on file "\\xxx\xx.bak:" 64(The specified network name is no longer available.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally
When Validating the .BAK file with
RESTORE VERIFYONLY option
The result of the query is The backup set 1 is Valid.
Any thoughts on this issue(Presently working with Admin team on network issue).
July 28, 2011 at 1:39 am
Search this, or any other SQL Server forum, and you will see so many other people having issues backing up over a network.
Almost without exception, the advice is... Don't backup directly to the network.
Backup to a local drive, then copy to the network using something like xcopy.
July 28, 2011 at 3:34 am
This may occur due to temporary network glitch while taking backup.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply