First things first, you will need to get a copy of a backup database called FoodDB.
This can be obtained by raising a Zendesk ticket asking IT Support to restore the database using DPM.
IT will let you know where they have stored the .mdf and .ldf files for FoodDB. If you go to this location and copy the files on to your local machine, you can attach them to your SQL Server by running Management Studio as an administrator and following these instructions:
- Right click on Databases
- Click Attach
- In the Attach Database dialog click Add
- Browse to the .mdf and .ldf file location
- Select FoodDB.mdf and click OK
- When you return to the Attach Database dialog click OK
There are no foreign key constraints to worry about in this database, and the orders are all stored in the 'Orders' table.
Please sign in to leave a comment.