Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Backup Failed but backup file is created Expand / Collapse
Author
Message
Posted Monday, February 25, 2013 1:50 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 2, 2014 8:11 PM
Points: 16, Visits: 160
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.
Post #1423768
Posted Monday, February 25, 2013 3:09 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, January 21, 2014 8:29 AM
Points: 244, Visits: 476
Hi,

have you first checked the backup with restore headeronly?
Occurs the error on every backup?


Kind regards,

Patrick Fiedler
Consultant

Fiedler SQL Consulting

www.fiedler-sql-consulting.de
Post #1423789
Posted Monday, February 25, 2013 3:33 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 2, 2014 8:11 PM
Points: 16, Visits: 160
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.
Post #1423798
Posted Monday, February 25, 2013 3:40 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 10:16 AM
Points: 20,860, Visits: 32,884
Is this a native backup or are you using third party software to compress the backup?



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1423800
Posted Monday, February 25, 2013 3:46 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 2, 2014 8:11 PM
Points: 16, Visits: 160
It is a native backup. I use SSIS script job to fire the backup command.
Post #1423804
Posted Monday, February 25, 2013 5:35 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, January 21, 2014 8:29 AM
Points: 244, Visits: 476
On which Type of device you are backing up?

Kind regards,

Patrick Fiedler
Consultant

Fiedler SQL Consulting

www.fiedler-sql-consulting.de
Post #1423829
Posted Monday, February 25, 2013 5:41 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 2, 2014 8:11 PM
Points: 16, Visits: 160
I backed up the database on a share folder. The media is raid 5 disks.
Post #1423830
Posted Monday, February 25, 2013 11:40 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, January 21, 2014 8:29 AM
Points: 244, Visits: 476
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?


Kind regards,

Patrick Fiedler
Consultant

Fiedler SQL Consulting

www.fiedler-sql-consulting.de
Post #1423892
Posted Tuesday, February 26, 2013 4:59 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 8:15 AM
Points: 224, Visits: 892
Have you restored to a test server and ran CHECKDB on the restored database?

'Only he who wanders finds new paths'
Post #1424009
Posted Tuesday, February 26, 2013 7:23 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 2, 2014 8:11 PM
Points: 16, Visits: 160
yes, everything is good. I could not figure out why the file is there when the backup command is terminated.
Post #1424075
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse