Restore Existing Database for EventPro On-Prem Active Directory Integration

In most cases, an EventPro Training or Support Specialist will provide you with a database that has been converted from a previous database and/or filled with information that you have provided.

You need to restore that database to the SQL Server before proceeding with EventPro installation.

With this process, you will be restoring the existing database over the new "placeholder" database you just created in the previous step.

Typically, the database is sent as a .BAK file, which you can restore in SQL Server Management Studio (SSMS).

Ensure that the existing database is stored on the same machine as SQL Server.

1.Run SQL Server Management Studio.

You may have a different version of SQL Server Management Studio than that depicted below, but the functions and settings should be essentially the same.

2.In the Connect to Server dialog, ensure that the correct Server name is selected (Network Computer Name\Named Instance, e.g. MYDBSERVER\SQLEXPRESS).

Select either Windows Authentication or SQL Server Authentication.  If you choose SQL Server Authentication, enter the User Name and Password.  

(Remember that when installing SQL Server earlier, you chose between Windows Authentication and Mixed Mode (SQL Server + Windows Authentication), and set the password for the sa account.)

Click Connect.

3.In the Object Explorer panel of Microsoft SQL Server Management Studio, expand the Databases so that you can see EventProData.

Right-click on EventProData, and select Tasks > Restore > Database.

4.The Restore Database window appears.

5.Under Source, select Device, and click the ellipsis next to the field.

a.The Select Backup Devices form appears.

b.Click the Add button. The Locate Backup File window appears.

c.In the Locate Backup File window, locate the existing database that your EventPro Trainer sent to you, which should have been saved on the same machine as SQL Server, as noted above.  

d.Click OK in the Locate Backup File window, and again in the Select Backup Devices window to return to the Restore Database form.

6.Back in the Restore Database form, under Destination, the Database should be set to EventProData.

7.Ensure that you have selected the correct Source and Destination.

8.In the left Select a Page panel, click on Options.  Select the first checkbox, Overwrite the Existing Database (WITH REPLACE). (In this situation, we want the restored, prepared database from EventPro Training/Support to overwrite the blank "placeholder" database that we created in the previous step.)

9.Click OK at the bottom of the Restore Database dialog to begin the restore process.  

10.When the restore is complete, you should receive a success dialog.  Click OK.

11.You can now proceed to Give Database Rights to Users.