Error Transection log backup .

[Former Member]

Hi,

We are useing MS SQL(2005) DB sap we faceing error when takeing backup of transection log through MS SQL Studio as :

System.Data.SqlClient.SqlError: A nonrecoverable I/O error occurred on file "I:\SD3LOG1\SD3LOG1.ldf:" 1117(The request could not be performed because of an I/O device error.). (Microsoft.SqlServer.Smo)

Thank you,

Regards,

Madhus.

[JPReyes · Accepted solution]

The request could not be performed because of an I/O device error

I/O error means you either have a hardware failure or the filesystem were the file is located is not available or unreadable.

Check your hardware and the file integrity.

Regards

Juan

[Former Member]

Madhus

If possible, try rebooting the SQL server before the backup.

Hope this helps!

PJ

[Former Member]

Hi,

Once check with your device it is connected or not.

Regards,

Muralidhar

[Former Member]

hi,

Device connected perfectly backup is run up to 20% after that it shows error

System.Data.SqlClient.SqlError: A nonrecoverable I/O error occurred on file "I:\SD3LOG1\SD3LOG1.ldf:" 1117(The request could not be performed because of an I/O device error.). (Microsoft.SqlServer.Smo)

.

Regards,

Madhus.

Edited by: madhus.frnds on May 18, 2009 2:12 PM

[Former Member]

Hi,

Check, if the disk has enough space. Also see the log in db13 if you are scheduling the backup using this for more detail.

Regards,

Vamshi.