Restoring SQL Server database from .bak file

[nondrinker]

I am trying to copy a database from Production server to the development server.
I have created a back file on the producton database and then copied it over to the
C drive of development database.

Now i am trying to use that .bak file to use in a restore procedure on the development database.

Here is how i am trying to do it.
Right click on the databases
Choose All Tasks-->Restore Database
On the General Tab i am choosing "From Device"
Then Select Devices.
Then i am clicking on the Select Devices and then choosing: C:\OrdersData2.bak
I click Ok.
On the Options tab i am choosing: "Force restore over existing database"
Once i select the OrdersData2.bak it starts showing the names master and mastlog in the Logical "File name column".
In the "Move to physical file name" columns it starts showing: C:\Program Files\Microsoft SQL Server\MSSQL\data\master.mdf and C:\Program Files\Microsoft SQL Server\MSSQL\data\mastlog.ldf

Back on the General Tab, in the Restore as database naming it as: OrdersData_2

After doing all this, when i click on Ok, it says:
"Restore of database 'ordersData_2' completed successfully.

The problem is that after doing all that, when check the ordersData_2 database, it has only the system tables in it and looks like a brand new database, with no user tables, stored procedures copied from the original database.


Any help will be appreciated.
Thanks.

 

[PHV]

You may get more accurate answers in the SQL Server forum.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244