Lost form submissions when restoring database from server

Hi,

Can you recommend a way to copy a server database to the localhost where you won't lose any form submissions? I used SSMS to create a backup of the server database. I then restored the database to the localhost database. However, after logging into the back office (the passwords changed so I had to change the hex value in the user table) the form data is no longer there. Any suggestions?