Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Intermitant Backup error


Intermitant Backup error

Author
Message
Catrina Bradford-281110
Catrina Bradford-281110
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
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
Exclamation
free_mascot
free_mascot
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2879 Visits: 2235
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."
Chandra Sekhara Vyas Dhara
Chandra Sekhara Vyas Dhara
Hall of Fame
Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)

Group: General Forum Members
Points: 3963 Visits: 1149
Check the following link

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



Catrina Bradford-281110
Catrina Bradford-281110
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
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
free_mascot
free_mascot
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2879 Visits: 2235
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."
Catrina Bradford-281110
Catrina Bradford-281110
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 11
Sorry not the same error
Catrina Bradford-281110
Catrina Bradford-281110
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 11
Database backed up: DatabaseBigGrinBName, 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
KenpoDBA
KenpoDBA
SSC-Addicted
SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)SSC-Addicted (476 reputation)

Group: General Forum Members
Points: 476 Visits: 611
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.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant

Minion Maintenance is FREE:


Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36089 Visits: 18738
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
My Blog: www.voiceofthedba.com
Ian Yates
Ian Yates
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1056 Visits: 445
Are you seeing anything extra in the SQL Server log?



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search