so if the restore worked thats not the problem. What status does the database show as in SSMS?

What does 'select state_desc from master.sys.databases' return for your database

If the name of the database is the same, and the logical file names are the same for the two files prod has, a straight restore database with no extra clauses should work.