| | How do I restore my Estimating databases using SQL Server Management Studio (SSMS)? (SQL) |
| Resolution |  CAUTION: The following procedure requires in-depth knowledge of database engines for your Sage product, such as Microsoft SQL Server, Pervasive SQL, and MySQL. Sage can't assist with database administration and isn't responsible for errors resulting from database changes. Back up your system and application databases required for a complete restore. Consider contacting a certified consultant or your database administrator for assistance.
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.
|
|