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

This article explains how to create a backup of a Dental System, Dental Desktop, or UNITE database using Microsoft SQL Server Management Studio (SSMS).

Installing Microsoft SQL Server Management Studio

Step 1: Download and install Microsoft SQL Server Management Studio (SSMS).

Finding the Database Credentials

The database credentials can be obtained from either Dental System or Dental Desktop, depending on the product being used.

For Dental System

Step 1: Open "Control Panel".

Step 2: Select "General".

Step 3: Locate the database credentials.

For Dental Desktop

Step 1: Navigate to the Dental Desktop installation folder.

The default location is: C:\Program Files\3Shape\Dental Desktop

Step 2: Open the "InstallationLogFile.log" file.

Step 3: Scroll to the bottom of the file.

Step 4: Review the entries from bottom to top until the database credentials are located.

Connecting to the Database

Step 1: Open Microsoft SQL Server Management Studio.

Step 2: Connect to the "THREESHAPEDENTAL" SQL instance using the credentials identified in the previous section.

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".

Creating a Database Backup

Step 1: Expand "Databases".

Step 2: Right-click the appropriate database.

For Dental System Select: DentalManager

For Dental Desktop or UNITE Select: DentalDesktop

Step 3: Select "Tasks".

Step 4: Select "Back Up...".

Configuring the Backup

Step 1: Verify that "Full" is selected as the backup type.

Step 2: Click "Add..." to specify the backup file location.

Step 3: Verify that only one backup location is listed.

If additional locations are present:

Step 4: Select the unwanted location.

Step 5: Click "Remove".

Selecting the Backup Location

You can save the backup using one of the following methods.

Using the Default Location

Leave the default backup location unchanged: C:\Program Files\Microsoft SQL Server\MSSQL**.THREESHAPEDENTAL\MSSQL\Backup

Step 1: Click "OK".

Using a Custom Location

Step 1: Click "...".

Step 2: Browse to the desired folder.

Step 3: Enter the backup file name.

Step 4: Click "OK".

Creating the Backup

Step 1: Verify that the correct backup file is selected.

Step 2: Click "OK" to start the backup process.

Verifying the Backup

After the backup is completed successfully, the following message is displayed:

"The backup of database 'DentalManager' completed successfully."

or

"The backup of database 'DentalDesktop' completed successfully."

Restoring the Backup

A backup created using Microsoft SQL Server Management Studio can also be restored using Microsoft SQL Management Studio.

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.