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.