July 6, 2016 at 10:45 pm
Dear Experts,
We are getting error while taking backup of a database on local Drive( Operating system error 1117 (The request can not be performed because of I\O device error)).
Details
SQL server 2008R2
Thanks in advance
NM
July 25, 2016 at 6:25 pm
If the server on VMWare, then you may want to check the following:
https://support.microsoft.com/en-us/kb/2519834
Sue
July 25, 2016 at 10:10 pm
naren.ece2012 (7/6/2016)
Dear Experts,We are getting error while taking backup of a database on local Drive( Operating system error 1117 (The request can not be performed because of I\O device error)).
Details
SQL server 2008R2
Thanks in advance
NM
Quick questions, what is the full output of SELECT @@VERSION
Is the server a virtual machine?
😎
July 28, 2016 at 3:07 pm
no the server was not in VMware.
July 28, 2016 at 4:26 pm
I'd do a DBCC CHECKDB of all the databases. Also try a backup to a network drive or another physical drive if that's feasible to see if you still get the same errors. You might even want to try just another location on the disk you are using for your backups.
The windows event logs would be the other thing you would want to go through since that error is usually thrown from Windows due hardware issues. If you get the error again, I'd check the windows event logs for the time of the backup error as well.
Sue
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply