How to backup Dental System/Dental Desktop/UNITE database with SSMS
19/04/20241. Download Microsoft SQL Server Management Studio (optionally can be newer than version installed) and install the software.
2. If Dental System is used, go to Control Panel -> General to find the database credentials.
If Dental Desktop is used, go to executable folder (by default, C:\Program Files\3Shape\Dental Desktop) -> find InstallationLogFile.log -> scroll to the very bottom and from bottom up for this line:
3. Start Microsoft SQL Management Studio and connect to the THREESHAPEDENTAL instance using the above credentials.
- 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.
NOTE! The values may be different if the system was configured using non-default settings, using a pre-existing SQL server instance. In this way set the the credentials of the existing instance.
4. Once connected, go to Databases, right click on a relevant database and choose Tasks --> Back Up...
- select DentalManager database- for Dental System installation;
- select DentalDesktop database - for Dental Desktop or UNITE;
5. Choose Backup type Full and click Add.. to specify custom location for backup file.
NOTE! Make sure only one location is specified, select the previous location and click Remove button to remove it.
6. You may save the backup file in 2 ways:
- leave the default location C:\Program Files\Microsoft SQL Server\MSSQL**.THREESHAPEDENTAL\MSSQL\Backup and press OK:
- Click ... to add a new file location and then indicate the folder and file name:
8. Press OK to return to the backup creation window, select the new backup file name and press OK to create the backup.
9. When finished you should get the message: The backup of database 'DentalManager' (or 'DentalDesktop') completed successfully:
10. The backup can be restored using Microsoft SQL Management Studio as well.