# Restore Database

You can restore the database using the database file you backed up.
For information on how to set up backup, please refer to the following link.

Reference Link

# Check the settings

  1. Make sure that the status of DICOMApp is "Stopped".
    If the status of DICOMApp is "Running", click "Stop" to stop PACS.

Make sure that SonicDICOM PACS is Stopped

  1. Click the "Database" tab.
  2. Check which database is in use.
    The restore procedure is different between Microsoft SQL Server Compact and Microsoft SQL Server.

Check which database is in use

  1. Check the backup location for the database file.

Check the backup location for the database file

  1. Click the "Server" tab.
  2. Check the path of the backup location.

Click Server tab

# In the case of Microsoft SQL Server Compact

  1. Open the backup location of the database file.

Open the backup location of the database file

Info

A backup of the database files is created for each day of the week.
The backed up file names will be<original file name>_<day of the week>.bak.

  1. Copy the database file to be restored and store it in any location.

WARNING

Be sure to use all database files created on the specific day of the week.
Restoring with only a part of database files may cause unexpected behavior.
Also, please be careful not to mix files created on different days of the week.

  1. Delete_<day of the week>from the file name of the copied file and change the extension tosdf.
  2. Overwrite the existing file in the folder where SonicDICOM PACS is installed with the file whose name has been changed.

Overwrite the existing file with the file whose name has been changed

Info

The default installation location of SonicDICOM PACS is C:\Program Files\SonicDICOM PACS.

# In the case of Microsoft SQL Server

  1. Launch Microsoft SQL Server Management Studio.
  2. Make sure the displayed "Server Name" is the same as the instance that PACS is using and click "Connect".

Connect to MS SQL Server

Info

If you use "Default instance", Computer Namewill be displayed.
If you use an instance other than "Default instance", Computer Name\Instance Namewill be displayed.

  1. Right click "Database".
  2. Click "Restore Database".

Click Restore Database

  1. Click "Device".
  2. Click "...".

Click Device and click ...

  1. Click "Add".

Display the dialog to select backup device

  1. Select the database file to be restored.
  2. Click "OK".

Select the database file to be restored

Info

A backup of the database files is created for each day of the week.
The backed up file names will be <original file name>_<day of the week>.bak.

  1. Click "OK".

Start restoring the database

  1. When the selected database file has been successfully restored, the following dialog will be displayed.

The selected database file has been successfully restored

  1. Repeat the steps from 8. to 11. with all the database files created on the same day of the week as the one selected in 8. to restore.

WARNING

Be sure to use all database files created on the specific day of the week.
Restoring with only a part of database files may cause unexpected behavior.
Also, please be careful not to mix files created on different days of the week.