Db restore failed

Hi
I'm trying to restore a db from backup.

When I just tried, I got this message: "failed with the operating system error 21(The device is not ready.). (Microsoft.SqlServer.Smo)"

I restored a db without problems yesterday.

One thing that's changed is my PC's name, which changed that yesterday because of a conflict on the network.

Any idea what the problem is?

Thanks.
Co
LeprechaunAsked:
Who is Participating?
 
rickchildConnect With a Mentor Commented:
See here:  http://www.sqlservercentral.com/Forums/Topic361087-357-1.aspx

By default it will try to restore to the last path, change this in Options Tab under Restore As.
0
 
rickchildCommented:
Sounds like you may have answered your own question, the change in PC name could have affected this, particularly if the backup is on the network.

Are you restoring from File or from Backup Device?
0
 
jorge_torizResearch & Development ManagerCommented:
Verify if sql server has access to the physical path of this query:

RESTORE FILELISTONLY
FROM DISK = 'C:\YourBackup.bak'
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.