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 |
ann
Posting Yak Master
220 Posts |
Posted - 2009-09-30 : 12:06:48
|
I have a backup from the production server that I am trying to restore to a dev server. I created a new db in the dev server and ran scripts so that I would have the same tables, sp's as the db in production. When I try to restore, I get the following error msg:Device Not ReadyI'm not even sure if this is the best way to do this. Can someone please help me with this? ThanksPS: Both the backup and new db are sql server 2005 |
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-09-30 : 12:15:24
|
What was the restore statement that you ran?--Gail ShawSQL Server MVP |
|
|
ann
Posting Yak Master
220 Posts |
Posted - 2009-09-30 : 12:48:03
|
I ran the restore from Management Studio - which gave me a bunch of headaches including the fact that the restore as in the option section was pointing to a different directory than the one it should have pointed to. Once I fixed that, I ran into "not in exclusive use" issues, and on, and on. I finally got it to work, but heaven help me if I had to do this again.What is the best way to do this? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|