Use SSMS to restore a backup or .bak file to the new server and instance.
- Copy the .bak file(s) from the old server to the new server (default location should be C:\Program Files\Microsoft SQL Server\[instance name]\MSSQL\Backup)
- On the new server launch SSMS by going to Start, All Programs, Microsoft SQL Server [version], SQL Server Management Studio
- Connect to the instance where you would like to install the databases on the new server. (by default it is SAGE_ESTIMATING)
- Right click on Databases under the instance in the Object Explorer pane and select Restore Database...
- In the Restore Database window in the Destination for restore enter a Name for the database (ie Estimates for your estimates database)
- In the Source for restore section select the radio button for From Device and click the [...] button.
- Browse to the copied location of the .bak files from step 1 of the restore above.
- In the Select the backup set(s) to restore check the box in the Restore column and click ok
- A message stating the backup was successfull should show on the screen
*Note: For the Estimates database ONLY you may have to perform the steps under related resources below in order to re-align the user ID's with the new Estimating Security settings on the new server. If this step isn't done then a message stating "You are not currently set up as a user of the selected Estimating server" will appear.