Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Restore Failure

Author  Topic 

AAAV
Posting Yak Master

152 Posts

Posted - 2014-03-04 : 10:24:18
Hello,
We are trying to restore a database with the mdf on one physical hard drive and log on another to make use of the drive speeds.

But we are getting the following error randomly.

Msg 3203, Level 16, State 1, Line 1
Read on "G:\TempDb\Mwork.bak" failed: 1117(The request could not be performed because of an I/O device error.)
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

The chkdisk on the physical drives says the drives are good.
Has anyone worked with having the database files(mdf&log) in different drives?

Thanks
aaav

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-03-04 : 11:05:16
I have plenty of databases on different drives and have no issue with restores. It sounds like G is not accessible at times. What does the event log show?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

AAAV
Posting Yak Master

152 Posts

Posted - 2014-03-04 : 13:44:42
Application
BackupIoRequest::ReportIoError: write failure on backup device 'G:\TempDb\Vinbase_yahoo.bak'. Operating system error 1117(The request could not be performed because of an I/O device error.).
System
The IO operation at logical block address 7288009 for Disk 0 was retried.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-03-04 : 14:24:13
When it succeeds, does DBCC CHECKDB return any errors?

I would open a case with Microsoft.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -