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.
| 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 1Read 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 1RESTORE 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?Thanksaaav |
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
AAAV
Posting Yak Master
152 Posts |
Posted - 2014-03-04 : 13:44:42
|
| ApplicationBackupIoRequest::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.).SystemThe IO operation at logical block address 7288009 for Disk 0 was retried. |
|
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Restore Failure