Search

Juris® Answer Center

Restoring Up Your Juris Database Using SQL Server

  • Updated

You can restore backed up Juris databases using the Restore feature available in the Microsoft SQL Server Management Studio tool.

You can also use the Juris Management Console to restore your databases. For more information, see Back Up and Restore Juris SQL Database .

For more information on the database backup process, see Backing Up Your Juris Databases

  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. Search your operating system 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 / Restore / Database.

    The Restore Database - Juris dialog box appears.

  7. In the Source area on the right side of the dialog box, click the Device option.

  8. Click the ... button adjacent to the Device option (on the far right side of the dialog box).

    The Select backup devices dialog box appears.

  9. Click the Add button.

    The Locate Backup File dialog box appears.

  10. Browse to the location of your backup file, and click the file to select it.

  11. Click OK.

    You are returned to the Select backup devices dialog box.

  12. Click OK.

    You are returned to the Restore Database - Juris dialog box.

  13. In the Source area on the right side of the dialog box, select the Juris database from the Database drop-down list.
  14. In the Destination area on the right side of the dialog box, verify that the Juris database is selected from the Database drop-down list. This selection should have been automatically updated when you selected the Juris database in the previous step.

  15. In the Restore plan area on the right side of the dialog box, verify that the check box in the Restore column that corresponds to the Juris database is selected.

    Your dialog box should appear as shown below.

  16. In the Select a page pane on the left side of the dialog box, click Options.

    Additional restore settings appear on the right side of the dialog box.

  17. In the Restore options area on the right side of the dialog box, define the appropriate restore settings.
    1. Click the Overwrite the existing database (WITH REPLACE) check box.
    2. Verify that the RESTORE WITH RECOVERY option is selected from the Recovery state drop-down list.

  18. Click OK.

    The restore process is initiated, and a message appears when the process is completed successfully.

  19. Click OK.
  20. Repeat this procedure to restore the JBills database.
    1. Right-click the JBills database, and click Tasks / Restore / Database.
    2. Specify the correct backup file (as described in step 7 through step 12 above)
    3. Specify the necessary restore options and start the restore process (as described in step 13 through step 18 above)
    4. Click OK once the message appears showing you that the restore process completed successfully.

  21. Close SQL Server Management Studio. The entire database restore process is now complete.