Backup: (Estimating Management Console)

Backing up databases

You use the Back Up tool to back up selected standard and estimating databases in your Sage Estimating system.

When you back up databases, the Estimating Management Console creates a folder that contains compressed versions of the databases you select, placing the folder in a location that you specify. It labels the folder with the date and the time of the backup for easy identification, should you need to restore a database later.

You can back up any number of databases at the same time. Although the backup copies are stored together in the same folder, when you restore databases, you select individual databases from this folder.

Before you start

Make sure no other users are working with the databases you are going to back up. None of the fields on the Back Up Databases tab are available until you confirm that you have exclusive access to the databases.

To back up databases:
1.On the ribbon in the Estimating Management Console, click the [Tools] button.

2.In the navigation pane, click Backup.

3.After verifying that no users are working with the databases you are going to back up, select the Exclusive access confirmed check box on the Backup Databases tab.

Estimating Management Console displays all your Sage Estimating standard and estimate databases in the table.

4.In the table, select the databases you want to back up.

5.In the Select the location to save the backup folder, type the path to the parent folder where the backup folder will be placed.

Tip: It is a good idea to use a consistent location to store backup folders for easier retrieval, later.

6.Click [Back Up].

Backup: (SQL Server Management Studio (SSMS))

Use SQL Server Management Studio (SSMS) to create a backup of the database(s) in your instance.

1. Start SSMS by going to Start, All Programs, Microsoft SQL Server [version], SQL Server Management Studio
2. Connect to the instance where your estimating data resides (by default it is SAGE_ESTIMATING)
3. Right click on the database under your instance and select Tasks, Back Up to open the backup database window.
4. Under Source select the database to backup...
5. For the backup type select Full and for the component type select Database.
6. Under Backup Set, type a name for the database backup you are creating in the Name box.
7. Select the backup destination from the Destination list. *This will go to the default C:\Program Files\Microsoft SQL Server\[instance name]\MSSQL\Backup but another destination value can be selected.
8. Click OK a Backup of database completed successfully message appears when the operation is finished.

*Note: All of the information below can be found in the SageEstimatingSQLServerGuide.pdf