Backing Up Your Databases Using SQL Server 2008 / 2012

You need to use Microsoft SQL Server Management Studio to back up for two Juris system databases: Juris and JBills.

This procedure describes how to perform these backups using the following versions of SQL Server:

• SQL Server 2008
• SQL Server 2012

If you are using SQL Server 2014, see Backing Up Your Databases Using SQL Server 2014 for complete instructions.

Backing Up the Juris Database

The procedure for backing up the Juris database involves accessing SQL Server Management Studio and specifying backup options such as the set name, backup location, and backup file name.

1. Verify that all users have closed the Juris client application.
2. Verify that you are logged into the computer that is running SQL Server, and that you are the administrator or a user with administrative privileges.
3. Open SQL Server Management Studio using one of the following methods, based on your operating system:
   • Windows Server 2008: Click Start, click All Programs, click Microsoft SQL Server, and click SQL Server Management Studio.
   • Windows 8 / Server 2012: Search for SQL Server, and click SQL Server Management Studio in the search results.

4. On the Connect to Server dialog box, specify your credentials and click Connect.

   The Microsoft SQL Server Management Studio dialog box appears.

   

5. On the left side of the dialog box, click the + icon adjacent to the Databases node.

   Two Juris-related entries should be listed: Juris and JBills. Each name is appended with your client code (as specified during your Juris installation).

   

6. Right-click the Juris database, and click Tasks / Back Up.

   The Back Up Database - Juris dialog box appears.

   

7. From the Backup type drop-down list, verify that Full is selected.

8. In the Backup set area (middle portion of the right side of the dialog box), enter the name of your backup group in the Name text box. All Juris databases backups will be contained within this set.

   A suggested name is provided, which you can edit, as desired. For example: JurisBackupSet

   Tip

   Be sure to note this set name, as you will use it later when backing up the other Juris system database (JBills).

9. In the Destination area (lower portion of the right side of the dialog box), click the Add button.

   The Select Backup Destination dialog box appears, which allows you to specify the name of the database backup file or a predefined backup device.

10. If you are specifying a backup file, you need to navigate to the appropriate location and specify a file name.

    1. Click the ... button adjacent to the to the File name text box.

       The Locate Database Files dialog box appears.

    2. Navigate to the appropriate location and click the folder that will contain your backup.

    3. In the File name text box, enter the name and file extension of the database backup file that will be created when the backup is executed.

       Caution

       You need to manually specify the file extension (.bak). For example: MyJurisBackup.bak

       Your dialog box should appear similar to the following example.

       

    4. Click OK.

       You are returned to the Select Backup Destination dialog box, and the file name you specified appears in the File name text box.

11. If you are specifying a backup device, you need to select it.

    1. Click Backup device.

    2. Select the predefined backup device from the corresponding drop-down list.

       

    For more information on creating backup devices, see Creating a New SQL Server Backup Device.

12. Click OK to close the Select Backup Destination dialog box.

    You are returned to the Back Up Database dialog box, and the new backup file or backup device is now listed in the large text box in the Destination area.

13. Click OK.

    The database backup is executed, and the success message appears.

    

14. Click OK to close the success message dialog box.

    You are returned to the main Microsoft SQL Server Management Studio dialog box. Now you need to backup the other database - JBills.

15. Proceed to Backing Up the Juris Database below.

Backing Up the JBills Database

The procedure for backing up the other Juris system database, JBills, is very similar to the procedure used for the Juris database. However, instead of defining a backup destination (and file) or backup device, the JBills database backup should be added to the destination previously created for the Juris database.

1. On the Databases node, right-click the JBills database, and click Tasks / Back Up.

   The Back Up Database - JBills dialog box appears.

2. From the Backup type drop-down list, verify that Full is selected.

3. In the Backup set area (middle portion of the right side of the dialog box), enter the name of your backup group in the Name text box. All Juris databases backups will be contained within this set.

   Although suggested name is provided, be sure to specify the same set name used for the Juris database backup. For example: JurisBackupSet.

4. In the Destination area (lower portion of the right side of the dialog box), click the destination previously defined when creating the Juris database backup.

   This action adds the JBills database backup to the same backup file as the Juris database backup.

5. Click OK.

   The database backup is executed, and the success message appears.

   

6. Click OK to close the success message dialog box.

   You are returned to the main Microsoft SQL Server Management Studio dialog box, and the entire database backup process is complete.

7. Proceed to Verifying Backup File Contents below.

Verifying Backup File Contents

Once you have backed up both the Juris and JBills databases, it is recommended that you view the contents of the backup file to verify that both databases are listed.

1. On the Databases node, right-click either of the two databases (Juris or JBills), and click Tasks / Back Up.

   The Back Up Database dialog box appears.

2. In the Destination area, verify that the destination used for the Juris and JBills database backup is selected (highlighted).

3. Click the Contents button.

   The Device Contents dialog box appears.

   

4. Verify that both the Juris and JBills databases appear in the Database column, as shown above.

5. Click Close to return to the Back Up Database dialog box.
6. Click Cancel.
7. Close Microsoft SQL Server Management Studio.