Post reply

Msg 3271

  • September 20, 2007 at 6:09 am

    #180997

    I received the following error message when attempting to backup a database.

     Msg 3271, Sev 16: Nonrecoverable I/O error occurred on file

    I looked on Microsofts web site and found nothing that helps.

    Thanks

    Glen

  • September 20, 2007 at 6:17 am

    #734892

    are you backing up to tape or disk ?

  • September 20, 2007 at 6:19 am

    #734893

    Disk

  • September 20, 2007 at 6:36 am

    #734897

    Check this link: http://msdn2.microsoft.com/en-us/library/aa337272.aspx

     

  • September 20, 2007 at 6:42 am

    #734898

    Thank you for the link.  I will do some additional research and check the available disk space.

  • September 27, 2007 at 5:42 am

    #736680

    Are you using a third party tool other then a SQL Backup?

    Are you using SQL Backups?

  • September 27, 2007 at 5:45 am

    #736681

    Sorry...

    Let me rephrase... are you using a third party backup tool other than using SQL Backups?

    And at wat time do your backups run?

    Are you making use of SQL Backups?

  • September 27, 2007 at 5:50 am

    #736682

    We are actually using both. We read several articles related to the MSg 3271 error. A couple of them stated the issue could be caused by the database or backup being placed over a bad location on the disk. We ran CHKDSK and no errors were reported. We read some other articles that stated the previous backup file could be corrupt. Therefore, I renamed the old backup file and ran a new backup manually using the same name. I checked output file attached to the job executing the backup the next morning and the backup ran successfully.

    The individual who runs the 3rd party backup utility is out this week. I am going to share my findings with him once he returns.

    Thanks to all that responded to my request.

Viewing 8 posts - 1 through 7 (of 7 total)

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