Restoring a Dental System, Dental Desktop, or UNITE Database Using Microsoft SQL Server Management Studio (SSMS)

Restoring a Dental System, Dental Desktop, or UNITE Database Using Microsoft SQL Server Management Studio (SSMS)

19/04/2024

Connecting to the Database

Step 1: Open Microsoft SQL Server Management Studio.

Step 2: Connect to the "THREESHAPEDENTAL" SQL instance.

Step 3: Verify that "Windows Authentication" is selected.

Step 4: Click "Connect".

If Windows Authentication is not available:

Step 5: Select "SQL Server Authentication".

Step 6: Enter the following credentials:

Login: sa

Password: 3SDMdbmspw

Step 7: Click "Connect".

The credentials may differ if the system was configured using non-default settings, such as an existing SQL Server instance. In this case, use the credentials configured for that SQL Server instance.

 

Selecting the Database to Restore

Step 1: Expand "Databases".

Step 2: Right-click the appropriate database.

  • Select DentalManager for Dental System.
  • Select DentalDesktop for Dental Desktop or UNITE.

Step 3: Select "Tasks".

Step 4: Select "Restore".

Step 5: Select "Database...".

Selecting the Backup File

Step 1: In the "Source" section, select "Device" instead of "Database".

The "Select Backup Devices" window opens.

Step 3: Click "Add".

Step 4: Browse to and select the backup file.

Step 5: Click "OK".

Step 6: Click "OK" to close the "Select Backup Devices" window.

Configuring the Restore Options

Step 1: Select the "Options" page.

Step 2: Enable "Overwrite the existing database (WITH REPLACE)".

Restoring the Database

Step 1: Click "OK" to start the restore process.

When the restore is completed successfully, one of the following messages is displayed:

  • "The database 'DentalManager' was restored successfully."
  • “The database 'DentalDesktop' was restored successfully.”

Step 2: Click "OK".

 


Contact 3Shape Support if you have any further questions.
 
For full information on correct usage consult the official Safety and Setup Guide and the most current Manual.

Was this article helpful?

Give feedback about this article