To install or restore a database with Microsoft SQL Server Management Studio 2017, do the following:
Open the Microsoft SQL Server Management Studio (Go to Start | All Programs | Microsoft SQL Server 2017 | SQL Server Management Studio).
Connect to the MSSQL instance of the Dentrix database.
Expand the Databases section.
Right-click the Dentrix database, and then click Restore Database.
Under Source, select Device.
Click the ellipsis (...) button.
As the Backup media type, select File.
Next to the Backup media list, click Add.
Browse to the .bak file's location, select the .bak file, and then click OK.
Click OK in the Select backup devices dialog box.
Under Backup sets to restore, select the Restore checkbox.
On the Select a page panel (on the left), click Files.
In the table under Restore database files as, in the Restore As column, click the ellipsis (...) button, and browse to the correct location where you want to restore the database file.
On the Select a page panel (on the left), click Options.
Under Restore options, select the Overwrite the Existing Database (WITH REPLACE) checkbox.
From the Recovery state list, select RESTORE WITH RECOVERY.
Click OK to start the restore.
When the message that states that the restore process is complete appears, click OK.