How do I restore my Estimating databases using SQL Server Management Studio (SSMS)? (SQL)
Description
Cause
Resolution
[BCB:2:Database warning:ECB]

Use SSMS to restore a backup or .bak file to the new server and instance.

  1. 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)
  2. On the new server launch SSMS by going to Start, All Programs, Microsoft SQL Server [version], SQL Server Management Studio
  3. Connect to the instance where you would like to install the databases on the new server. (by default it is SAGE_ESTIMATING)
  4. Right click on Databases under the instance in the Object Explorer pane and select Restore Database...
  5. In the Restore Database window in the Destination for restore enter a Name for the database (ie Estimates for your estimates database)
  6. In the Source for restore section select the radio button for From Device and click the [...] button.
  7. Browse to the copied location of the .bak files from step 1 of the restore above.
  8. In the Select the backup set(s) to restore check the box in the Restore column and click ok
  9. 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.



[BCB:164:Chat Estimating US:ECB]

Steps to duplicate
Related Solutions

How do I backup and restore my Sage Estimating database, using the Estimating Management Console? (SQL)