Restoring a Dental System, Dental Desktop, or UNITE Database Using Microsoft SQL Server Management Studio (SSMS)
19/04/2024Connecting 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.