Intermitant Backup error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » Intermitant Backup error

16 posts, Page 1 of 2

1 2 »»

Intermitant Backup error

Rate Topic

Display Mode

Topic Options

Author

Message

Catrina Bradford-281110

Posted Wednesday, January 30, 2008 3:35 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 22, 2013 9:05 AM
Points: 4, Visits: 8

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

Post #449247

free_mascot

Posted Wednesday, January 30, 2008 6:05 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 7:23 AM
Points: 1,771, Visits: 1,316

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

vyas

Posted Wednesday, January 30, 2008 6:20 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:02 AM
Points: 3,131, Visits: 1,056

Check the following link

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

Post #449319

Catrina Bradford-281110

Posted Thursday, January 31, 2008 3:53 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 22, 2013 9:05 AM
Points: 4, Visits: 8

It is only 10GB and there is plenty of space it gets to approx 80-90% finished and then fails over

Post #449855

free_mascot

Posted Thursday, January 31, 2008 4:05 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 7:23 AM
Points: 1,771, Visits: 1,316

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

Catrina Bradford-281110

Posted Thursday, January 31, 2008 7:02 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 22, 2013 9:05 AM
Points: 4, Visits: 8

Sorry not the same error

Post #449923

Catrina Bradford-281110

Posted Thursday, January 31, 2008 7:19 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 22, 2013 9:05 AM
Points: 4, Visits: 8

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

KenpoDBA

Posted Thursday, January 31, 2008 8:16 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 9:40 PM
Points: 314, Visits: 295

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