February 25, 2013 at 1:51 pm
Hey guys,
I have an issue with backing up a 80GB database over the network,
Here is the error:A nonrecoverable I/O error occurred on file "\\yyy\xxx.BAK" 64(The specified network name is no longer available.). BACKUP DATABASE is terminating abnormally.
I know it is network related issue but the backup file (xxx.bak) is created on directory (\\yyy).
I checked the backupset table on the server, that i backed up the database from, and verified that there is no entry related to (\\yyy\xxx.bak). I think it means that the database server does not recognize this backup file (xxx.bak) on directory (\\yyy)
I was doubting the integrity of the backup file, so I verify the file by using Restore Verifyonly; the result comes back: the backup file is valid.
I restored the backup file (xxx.bak) to a different database, and I was successfully restore that database to different server.
Here is my question:
How can the backup file is created when the backup command is terminated?
Thanks in advanced.
February 25, 2013 at 3:09 pm
Hi,
have you first checked the backup with restore headeronly?
Occurs the error on every backup?
[font="Arial"]Kind regards,
Patrick Fiedler
Consultant
February 25, 2013 at 3:33 pm
Yes I have.
I checked the file already using headeronly, filelistonly, and verifyonly. There is no issue with the file. The fact that i was able to restore that file on another server proving that the file is valid.
February 25, 2013 at 3:40 pm
Is this a native backup or are you using third party software to compress the backup?
February 25, 2013 at 3:46 pm
It is a native backup. I use SSIS script job to fire the backup command.
February 25, 2013 at 5:35 pm
On which Type of device you are backing up?
[font="Arial"]Kind regards,
Patrick Fiedler
Consultant
February 25, 2013 at 5:41 pm
I backed up the database on a share folder. The media is raid 5 disks.
February 25, 2013 at 11:40 pm
Have you tried to backup the Database on a local Drive? Is there the Same error?
Has the SQL Service Account Full Control of this Share?
[font="Arial"]Kind regards,
Patrick Fiedler
Consultant
February 26, 2013 at 4:59 am
Have you restored to a test server and ran CHECKDB on the restored database?
'Only he who wanders finds new paths'
February 26, 2013 at 7:23 am
yes, everything is good. I could not figure out why the file is there when the backup command is terminated.
February 26, 2013 at 2:31 pm
Have you looked for other errors in the Event Logs?
[font="Arial"]Kind regards,
Patrick Fiedler
Consultant
February 26, 2013 at 8:10 pm
Yes I looked at the event log and confirm that the command failed. Server event log and SQL event log both confirmed that the backup command failed.
February 27, 2013 at 1:13 am
No, i meant whether there are other errors like ntfs errors or Hardware errors in the Log.
An important Thing would also to check the permissions of the service Account. Has the Service Account Full Access to this folder?
[font="Arial"]Kind regards,
Patrick Fiedler
Consultant
February 27, 2013 at 7:28 am
No server/OS issue at all, and yes, account has permission to add/drop/modify file on that share folder. Weirdest thing ever.
February 27, 2013 at 12:57 pm
Hello. Are you using the (Reliability) backup option "Verify backup integrity" checkbox
during the backup session in SSIS?
Regards,
Mark G.
Viewing 15 posts - 1 through 15 (of 23 total)
You must be logged in to reply to this topic. Login to reply