SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 A nonrecoverable I/O error with backups
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

DBADolly
Starting Member

Ireland
2 Posts

Posted - 08/18/2011 :  08:01:19  Show Profile  Reply with Quote
we are experiencing the following error when backing up :

A nonrecoverable I/O error occurred on file "" BACKUP DATABASE is terminating abnormally.
Reading some posts on this forum I can see the suggestions appear to be Space issue with destination or some sort of corruption.
We have ruled out the space issue, and we are plentiful in that.
With the corruption, is this corruption at data record level, or at the physical file level?


Let Run a mile!

russell
Pyro-ma-ni-yak

USA
5071 Posts

Posted - 08/18/2011 :  10:16:04  Show Profile  Visit russell's Homepage  Reply with Quote
Does it happen every time, or just once? Likely just a network glitch/lost connection.

Not necessarily corruption.

Can you post the entire error message? Does it say "Network name no longer available"?

Edited by - russell on 08/18/2011 10:17:52
Go to Top of Page

DBADolly
Starting Member

Ireland
2 Posts

Posted - 08/25/2011 :  05:45:56  Show Profile  Reply with Quote
happens everytime, we found out we had a corruption issue on our SAN

Let Run a mile!
Go to Top of Page

robincham
Starting Member

2 Posts

Posted - 12/07/2011 :  05:38:22  Show Profile  Reply with Quote
hi..

I think your database is corrupted that is why error is popping while taking Backup. Why don't you try file recovery software to recover the corrupted database.

Recover your database first and later you can take the Backup. One tool to which i am familiar is Remo Recover software. You can download the free demo version. Try this, hope this will work for you.

You can take the help of following URL

http://www.remosoftware.com/file-recovery-software
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000