Restoring Development DB from Production

[civilwarjunky]

I have created a development database called CustomerRelationsDev and I want to restore a copy of my production database to it, and it is called CustomerRelations. I made a backup of CustomerRelations. How do I get CustomerRelationsDev to Restore from my production backup. I have tried changing file before and after backup is complete and I keep getting errors upon trying to restore it. Can you help.

 

[Corran007]

Please post the syntax you are using to restore it.

You need to change the file paths assuming your prod and dev do not have the same system setup

 

[DrSql]

Make sure your dev db in single user mode.
Right click on dev db, All Tasks ==>Restore Db.
From the parameters section==>
Show BAckup of DB: Select your Production Db.
Below it will show list all last backups available.
Select the latest and restore.
Good Luck


Dr. Sql
vpathisseril@yahoo.com
Good Luck.