How to restore backup of Dental System/Dental Desktop/UNITE database with SSMS

To restore database settings backed up using SQL Server Management Studio, follow these steps:

1. Start Microsoft SQL Management Studio and connect to the TREESHAPEDENTAL instance:

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

2. Right click on relevant database and choose Tasks --> Restore --> Database...

• select DentalManager database- for Dental System installation;
• select DentalDesktop database - for Dental Desktop or UNITE;

3. In the next window switch in Source from Database to Device:

4. Press ... to open "Select backup devices" window and press Add to browse for the backup file.

5. Select the backup file and press OK.

6. Press OK again to close "Select backup devices" window.

7. Go to Options and check the box next to "Overwrite the existing database (WITH REPLACE)".

8. Click OK to start database restore process. When finished you should get the message: "The database 'DentalManager' (or 'DentalDesktop') was restored successfully"

9. Click OK and close Microsoft SQL Server Management Studio.