Backup Failed but backup file is created

  • 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.

  • Hi,

    have you first checked the backup with restore headeronly?

    Occurs the error on every backup?

    [font="Arial"]Kind regards,

    Patrick Fiedler
    Consultant

    Fiedler SQL Consulting

    www.fiedler-sql-consulting.de
    [/font]

  • 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.

  • Is this a native backup or are you using third party software to compress the backup?

  • It is a native backup. I use SSIS script job to fire the backup command.

  • On which Type of device you are backing up?

    [font="Arial"]Kind regards,

    Patrick Fiedler
    Consultant

    Fiedler SQL Consulting

    www.fiedler-sql-consulting.de
    [/font]

  • I backed up the database on a share folder. The media is raid 5 disks.

  • 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

    Fiedler SQL Consulting

    www.fiedler-sql-consulting.de
    [/font]

  • Have you restored to a test server and ran CHECKDB on the restored database?

    'Only he who wanders finds new paths'

  • yes, everything is good. I could not figure out why the file is there when the backup command is terminated.

  • Have you looked for other errors in the Event Logs?

    [font="Arial"]Kind regards,

    Patrick Fiedler
    Consultant

    Fiedler SQL Consulting

    www.fiedler-sql-consulting.de
    [/font]

  • 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.

  • 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

    Fiedler SQL Consulting

    www.fiedler-sql-consulting.de
    [/font]

  • No server/OS issue at all, and yes, account has permission to add/drop/modify file on that share folder. Weirdest thing ever.

  • 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