The following instructions explain how to restore a SQL Server database from a backup taken from another computer (or from another database).  This uses an example of a database named “Solaria” however this name is interchangeable with a name of our choice.

Create and Back Up Solaria Database

If you do not have an existing database to restore into and you need to restore the database into a new database, you must first set up the new database and take a backup of it.

1. Open SQL Server Management Studio and log in as the system administrator.
2. Right click on the “Database” folder and select “New Database…”.

3. Enter the database name of “Solaria”.  Leave all defaults and click “OK” to save it.

4. Expand the “Databases” folder on the left side and click on the “Solaria” database name.
5. Select File --> Open from the menu and open the AcclaimSolariaDDL.sql script found in C:\Program Files\Acclaim Legal Solutions\Acclaim Solaria\database.
6. Click on the “Execute” button in the toolbar or press F5.  When it is finished, close the window with the script.
7. Right click on the “Solaria” folder and select Tasks --> Back Up…

8. Leave all defaults and click on “OK”.

You now have a backup of the Solaria database.

Restore From Backup File

Follow these steps for restoring another backup file to your Solaria database.

1. Copy the *.bak file you received to the backup folder for SQL Server.  This is usually found at C:\Program Files\Microsoft SQL Server\MSSQLXX.SQLSERVER\MSSQL\Backup.  This folder could vary depending upon SQL Server versions and installation location chosen.

2. Open SQL Server Management Studio and log in as the system administrator.
3. Expand the “Databases” folder on the left side to show the “Solaria” database name.
4. Right click on the “Solaria” database name and select Tasks --> Restore --> Database…  You will see the Restore Database Window.

5. Select the “Device” radio button and click on the ellipses (…) button.  On the “Select backup devices” window, click “Add” to find the .bak file you put in the SQL Server backup folder in step 1. Click on “OK’ until you are back on the Restore Database window.
6. In the “Destination” section of the window, select your “Solaria” database name in the “Database” dropdown list.
7. Select the “Files” section on the left side of the window.

8. Click on the ellipses (…) button next to the “Solaria” file name.  Select the “Solaria.mdf” file in the folder it shows you.
9. Click on the ellipses (…) button next to the “Solaria_log” file name.  Select the “Solaria_log.ldf” file in the folder it shows you.
10. Select the “Options” section on the left side of the window.

11. Check “Overwrite the existing database (WITH REPLACE)” option.  UNCHECK “Take tail-log backup before restore” if it’s checked.  Check “Close existing connections to destination database” if it’s enabled.
12. Click on “OK”.  The restore process will begin and a progress bar will display to show you its progress.  A message will display when it’s complete.

Modify AcclaimSolaria User

Before you can log into the database with the Acclaim Solaria application, you need to do the following:

1. Expand the “Databases” folder on the left side and click on the “Solaria” database name.
2. Click on the “New Query” toolbar option or press CTRL-N.  A blank query window will display.
3. Enter the following query text:         sp_change_users_login 'Auto_Fix', 'AcclaimSolaria'
4. Click on the “Execute” button in the toolbar or press F5.  You will see a few lines of black text display in a results pane, which is normal.

You can now close SQL Server Management Studio and log into the Solaria database with Acclaim Solaria.