Post reply

Full Backup failing

  • August 28, 2012 at 7:55 am

    #280485

    Hi,

    We have a database which is in size of 50 GB, this database backup is keep on failing now days with the below error msg.

    Server: Msg 3202, Level 16, State 1, Line 1

    Write on \\ServerName\D$\Backups\DBname_FULLbkp-04415PM' failed, status = 1130. See the SQL Server error log for more details.

    Server: Msg 3013, Level 16, State 1, Line 1

    BACKUP DATABASE is terminating abnormally.

    when i verified the sql server error logs i found the below error message

    Date8/28/2012 3:10:19 AM

    LogSQL Server (Current - 8/28/2012 8:08:00 AM)

    Sourcespid61

    Message

    Internal I/O request 0x7A994B08: Op: Write, pBuffer: 0x166F0000, Size: 983040, Position: 27389663744, UMS: Internal: 0x0, InternalHigh: 0xF0000, Offset: 0x608D1A00, OffsetHigh: 0x6, m_buf: 0x166F0000, m_len: 983040, m_actualBytes: 0, m_errcode: 1130, BackupFile:

    \\ServerName\D$\Backups\DBname_FULLbkp-04415PM

    Please give me your valuable suggestion for resolving this issue.

    Thanks,

    Babu

  • August 28, 2012 at 9:01 am

    #1530874

    I'm not 100% certain, but it could be that your backup file is corrupt. Try removing the file before you rerun the backup. Even though you're running INIT, it doesn't actually replace the file, but rather replaces the data & updates the header. Deleting the file entirely might solve it.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply