up vote 0 down vote favorite
share [g+] share [fb]

I looked at the files needed for the db to operate, and changed their paths to the dev's file system.

But dev server will not restore the backup file?

Do I need to get Master as well as MSDB, or is this a difference between versions of SSMS Enterprise SP1 and Developer SP2.

link|improve this question
What error are you getting? – Adam Brand Jul 1 '09 at 18:59
feedback

1 Answer

up vote 1 down vote

You don't need (or want) copies of master and msdb from the prod machine. It's not a difference between enterprise and developer, they're binary equivalents (just a different licensing scheme).

If your dev server is a lower version of SQL Server than your production server then you won't be able to restore to it from backups of the production server databases (even if the database compatibility level is set to the lower version).

Might also be a permissions thing on the dev server.

You might also have a corrupt backup file...

link|improve this answer
Could be wrong drive letter. The solution escapes me at the moment, but we do this all the time. – Kyle Hodgson Jul 1 '09 at 19:11
I have done this before numerous times. :) This time it is just not flowing through. – Stephen Jul 1 '09 at 19:42
Ok, I'm with you. Like AdamB said in the comment to your question, what error(s) are you getting? A lot can kill a restore... – squillman Jul 1 '09 at 20:13
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.