0

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.

Kenny Rasschaert
  • 9,045
  • 3
  • 42
  • 58
Stephen
  • 3
  • 2

1 Answers1

1

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...

squillman
  • 37,883
  • 12
  • 92
  • 146
  • Could be wrong drive letter. The solution escapes me at the moment, but we do this all the time. – Kyle Jul 01 '09 at 19:11
  • I have done this before numerous times. :) This time it is just not flowing through. – Stephen Jul 01 '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 01 '09 at 20:13