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
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Restore Failure
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AAAV
Posting Yak Master

152 Posts

Posted - 03/04/2014 :  10:24:18  Show Profile  Reply with Quote
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

USA
37464 Posts

Posted - 03/04/2014 :  11:05:16  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 - 03/04/2014 :  13:44:42  Show Profile  Reply with Quote
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

USA
37464 Posts

Posted - 03/04/2014 :  14:24:13  Show Profile  Visit tkizer's Homepage  Reply with Quote
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/

Edited by - tkizer on 03/04/2014 14:24:55
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.06 seconds. Powered By: Snitz Forums 2000