On SQLSERVER you need to double click on the Enterprise Manager icon to bring up the list of databases running on.
Double click on the + sign by the Microsoft SQL Server icon
Then click on the + sign by the SQL Server Group
Click on the + sign by (SQLSERVERNAME)
Click on the + sign by Databases to bring up the list of databases
Highlight the databases folder
Right click on the folder, and select New database, the window for Database Properties will appear.
In the name field, type in the nameofdb of the database you want to create, then click on the OK button. It might take a few seconds whilst the system adds the new database name.
Right click on the database name and highlight All Tasks, then select Restore Database. This will bring up the Restore Database window as shown below:
Change the Restore option to From Device as shown below:
Click on the Select Devices button. This will bring up the Choose Restore Devices
Click on the Add button, this will bring up the Choose Restore Destination
Move down the list until you can see the name of the database you want to restore, and highlight it, then click on the OK button.
Note that the File Name now shows the name of the nameofdb too.
Click on the OK button.
Again, note that the nameofdb is shown there now as well.
Click on the OK button, this will start the restore process on SQLSERVER. This can take several minutes dependent on the size of the database.
Once it has been successful, a message will appear stating it has been successful. Click on the OK button.
You can then close the Enterprise Manager window down.
