How to backup Dental System, Dental Desktop, or UNITE database with SSMS

Step 1: Download Microsoft SQL Server Management Studio and install the software. 

Step 2: If using Dental System, go to your computer's Control Panel and then General to find the database credentials (see example below on the left).
If you are using Dental Desktop, go to the executable folder (by default, C:\Program Files\3Shape\Dental Desktop), find InstallationLogFile.log, and scroll to the very bottom of the list and then line by line moving upwards look for the line below highlighted on the right.

Step 3: Start the Microsoft SQL Management Studio and connect to the THREESHAPEDENTAL instance using the above credentials for either Dental System or Dental Desktop (whichever you are using).

Step 4: Windows Authentication is used by default, click Connect to proceed. If Windows Authentication is not possible, switch to SQL Server Authentication, input sa for Login and 3SDMdbmspw for password, click Connect to proceed.

Step 5: Once connected, go to Databases, right click on a relevant database and choose ‘Tasks’, and then select ‘Back Up...’

• For Dental System installation select DentalManager database
• For Dental Desktop or UNITE select DentalDesktop database

Step 6: Select Full under the Backup type and click ‘Add...’ to specify a custom location for backup file. Make sure only one location is specified, if there is another location set select the previous location and click Remove.

Step 7: You may save the backup file in 2 ways:

1. Leave the default location C:\Program Files\Microsoft SQL Server\MSSQL**.THREESHAPEDENTAL\MSSQL\Backup and press OK:
    
    
2. Click ‘...' to add a new file location and then indicate the folder and file name:
    
    

Step 8: Press OK to return to the backup creation window, select the new backup file name and press OK to create the backup. 

Step 9: When finished you should get the message: The backup of database 'DentalManager' (or 'DentalDesktop') completed successfully:

Step 10: The backup can be restored using Microsoft SQL Management Studio as well.