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, February 26, 2013 2:31 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 looked for other errors in the Event Logs?

Kind regards,

Patrick Fiedler
Consultant

Fiedler SQL Consulting

www.fiedler-sql-consulting.de
Post #1424252
Posted Tuesday, February 26, 2013 8:10 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 2, 2014 8:11 PM
Points: 16, Visits: 160
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.
Post #1424303
Posted Wednesday, February 27, 2013 1:13 AM
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
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?


Kind regards,

Patrick Fiedler
Consultant

Fiedler SQL Consulting

www.fiedler-sql-consulting.de
Post #1424380
Posted Wednesday, February 27, 2013 7:28 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 2, 2014 8:11 PM
Points: 16, Visits: 160
No server/OS issue at all, and yes, account has permission to add/drop/modify file on that share folder. Weirdest thing ever.
Post #1424532
Posted Wednesday, February 27, 2013 12:57 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, July 18, 2014 1:26 PM
Points: 656, Visits: 467
Hello. Are you using the (Reliability) backup option "Verify backup integrity" checkbox
during the backup session in SSIS?


Regards,
Mark G.
Post #1424713
Posted Wednesday, February 27, 2013 3:02 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 2, 2014 8:11 PM
Points: 16, Visits: 160
No, I used standard script task to to issue the command 'backup database xxx to disk ='\\yyy\xxx.bak'
Post #1424779
Posted Monday, March 4, 2013 8:41 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 2, 2014 8:11 PM
Points: 16, Visits: 160
Do you guys have any theory of what happened?
Post #1426285
Posted Monday, March 4, 2013 4:43 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 8:58 PM
Points: 36,794, Visits: 31,253
Yes. SQL Server occasionally loses it's mind on such things. Over the last 16 years of using SQL Server, I've given up on trying to find the reasons. It appears to be because of spurious pips on the network when you have a waxing moon with the correct angular displacement to certain sunspots and the Red Wings are playing a home game on a rainy day but only during high tide and the coffee machine across the room is cycled.

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1426517
Posted Tuesday, March 5, 2013 3:57 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, January 23, 2014 9:40 AM
Points: 41, Visits: 161
HI Team,


I have one question ,when you terminated the backup activity ,did you received any error in windows event viewer and sql server error log. Can please let me what is error you have received .



Post #1426715
Posted Tuesday, March 5, 2013 7:51 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, January 23, 2014 9:40 AM
Points: 41, Visits: 161
HI Team,


I have one question ,when you terminated the backup activity ,did you received any error in windows event viewer and sql server error log. Can please let me what is error you have received .



Post #1426841
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse