Solved

Db restore failed

Posted on 2008-06-20
3
689 Views
Last Modified: 2009-03-27
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
0
Comment
Question by:Leprechaun
  • 2
3 Comments
 
LVL 13

Expert Comment

by:rickchild
Comment Utility
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
 
LVL 13

Accepted Solution

by:
rickchild earned 250 total points
Comment Utility
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
 
LVL 15

Expert Comment

by:jorge_toriz
Comment Utility
Verify if sql server has access to the physical path of this query:

RESTORE FILELISTONLY
FROM DISK = 'C:\YourBackup.bak'
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
This video discusses moving either the default database or any database to a new volume.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now