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 12»»

Intermitant Backup error Expand / Collapse
Author
Message
Posted Wednesday, January 30, 2008 3:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 25, 2013 2:54 AM
Points: 4, Visits: 11
Run backups to a repository server with 3 strips, stats 30


BACKUP DATABASE [SERVER NAME]TO [DEVICE NAME], [DEVICE NAME], [DEVICE NAME] WITH INIT, STATS = 30

30 percent backed up.
60 percent backed up.
Msg 3202, Level 16, State 0, Server [SERVER NAME], Line 913
Write on [DEVICE NAME] failed, status = 121. See the SQL Server error log for more details.
Msg 3013, Level 16, State 1, Server "SERVER NAME", Line 913
BACKUP DATABASE is terminating abnormally.

This fails on one strip and on a different strip each night

Have deleted devices and recreated
Have dumped to a different server

Post #449247
Posted Wednesday, January 30, 2008 6:05 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
What is the database size? Make sure you do have enough space for the backup. Generally once backup starts will completed successfully.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #449307
Posted Wednesday, January 30, 2008 6:20 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 6:22 AM
Points: 3,845, Visits: 1,086
Check the following link

http://forums.databasejournal.com/archive/index.php/t-16770.html



Post #449319
Posted Thursday, January 31, 2008 3:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 25, 2013 2:54 AM
Points: 4, Visits: 11
It is only 10GB and there is plenty of space it gets to approx 80-90% finished and then fails over
Post #449855
Posted Thursday, January 31, 2008 4:05 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
While running backup execute sp_who2 active for any blocking and deeply monitor server activity from which you may get some clue. Also check sql server and window error log if you can find more details

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #449860
Posted Thursday, January 31, 2008 7:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 25, 2013 2:54 AM
Points: 4, Visits: 11
Sorry not the same error
Post #449923
Posted Thursday, January 31, 2008 7:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 25, 2013 2:54 AM
Points: 4, Visits: 11
Database backed up: Database:DBName, creation date(time): 2006/06/09(10:41:53), pages dumped: 1421098, first LSN: 110597:15214:2, last LSN: 110597:15725:1, number of dump devices: 4, device information: (FILE=1, TYPE=DISK: {'Z:\.....\.....\DUMPNAME1.DAT', 'Z:\.....\.....\DUMPNAME2.DAT', 'Z:\.....\.....\DUMPNAME3.DAT', 'Z:\.....\.....\DUMPNAME4.DAT'}).
BackupMedium::ReportIoError: write failure on backup device 'Z:\.....\.....\DUMPNAME4.DAT'. Operating system error 59(An unexpected network error occurred.).
Internal I/O request 0x07DE5A10: Op: Write, pBuffer: 0x08AE0000, Size: 131072, Position: 1722489344, UMS: Internal: 0x0, InternalHigh: 0x20000, Offset: 0x66AB1A00, OffsetHigh: 0x0, m_buf: 0x08AE0000, m_len: 131072, m_actualBytes: 0, m_errcode: 59, BackupFile: Z:\.....\.....\DUMPNAME4.DAT
BACKUP failed to complete the command BACKUP DATABASE DBName
Post #449935
Posted Thursday, January 31, 2008 8:16 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 1:12 PM
Points: 320, Visits: 360
What happens if you don't stripe the backups? And it's only 10GB, why do you need to stripe it to begin with?

Watch my free SQL Server Tutorials at:
http://MidnightDBA.ITBookworm.com

Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://www.infoworld.com/blogs/sean-mccown
DBA Rant – http://dbarant.blogspot.com
Post #449974
Posted Thursday, January 31, 2008 9:46 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 4:13 PM
Points: 31,214, Visits: 15,660
Are these all on local drives? Or are some network?







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #450045
Posted Thursday, January 31, 2008 10:03 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 30, 2014 10:08 PM
Points: 1,038, Visits: 444
Are you seeing anything extra in the SQL Server log?


Post #450058
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse