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 Tuesday, March 5, 2013 3:26 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 2, 2014 8:11 PM
Points: 16, Visits: 160
This issue occurs every time we backup over the network during traffic time
Post #1427058
Posted Wednesday, March 6, 2013 4:04 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, October 13, 2014 8:00 AM
Points: 232, Visits: 823
Is there enough disk space space avaialble on your source drive?
Post #1427284
Posted Wednesday, March 6, 2013 7:42 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 1, 2014 4:58 PM
Points: 321, Visits: 1,495
I occasionally experience similar issues when backing up to a network share. When this occurs I'll run RESTORE HEADERONLY, RESTORE VERIFYONLY, then I'll restore it to another system and run DBCC CHECKDB. If it passes all three, I'm comfortable.

Here is my question:
How can the backup file is created when the backup command is terminated?

Here is one example (may or may not be your case) that may answer your question:
http://stujordan.wordpress.com/2012/06/14/sql-server-compressed-backups-fail-with-setendoffile-error/
Post #1427408
Posted Wednesday, March 6, 2013 7:53 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, October 17, 2014 6:39 AM
Points: 217, Visits: 870
Have to say we did have seemingly random errors on backups when backing up to a network drive. After lots of searching we put them down to network blips!

'Only he who wanders finds new paths'
Post #1427421
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse