How to Restore an Amicus Attorney by CARET database in SQL Management Studio

Restoring a Database using SQL Management Studio

CARET recommends that you have an IT person perform these steps.

1. Stop the Amicus Attorney Services (Amicus Server Service, Amicus Daily Check Service and Amicus Exchange Service)

2. Open SQL Server Management Studio and login to the SQL Server you want to restore the database to. It is best to either login as a Windows Administrator or as the SQL ‘sa’ user or Windows Authentication. Make sure the Server Name shows \\SERVER\Amicus (name of instance)

3. Expand Databases. Right click on the Amicus Attorney database and chose Tasks – Restore – Database

4. Choose the "Device" option under "Source".  

 5.  Then select this:

6.  This will bring up the following window.  Choose Add 

7.  Browse to the SQL backup (BAK) file you want to restore. 

8.  Click OK

9 . The next step is to select "Options" 

10.  Then choose the option to "overwrite the existing database (WITH REPLACE)  and Click OK.  This will Start the database restore. 

11. If the ‘To database’ (from the General page) matches the restore database backup (i.e. restoring to matching databases), the respective files will be overwritten as part of the restore.

If the ‘To database’ does not match the restore database backup (i.e. restoring to a different database), the ‘Overwrite the existing database with Replace’ will need to be checked for the restore process to complete.

Use this function with caution as you can potentially restore database backup information on top of data files from a completely different database.

Generally, you can tell the databases differ based on the ‘Original File Name’ which is the internal name SQL Server uses to reference the respective files.

12.  Once the restore is completed.  You will get this message.   However, If you receive an error “database in use” ensure that all the Amicus Attorney by CARET Services have been stopped. Exit SQL management Studio and restart the SQL Server and SQL Server Agent (Amicus) services.

13.  The same Steps need to be taken to restore the Amicus Media Database.