Restore Existing Database for EventPro On-Prem Software Standalone Installation

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

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.The Connect to Server dialog appears.

a.Ensure that the correct Server name is selected. The format will be Network Computer Name\Named Instance, e.g. MYDBSERVER\SQLEXPRESS, if you called the Instance SQLEXPRESS when installing SQL Server earlier.

b.Select Windows Authentication, assuming that you selected Windows Authentication as the Authentication Mode.

c.Click Connect.

3.In the Object Explorer panel of Microsoft SQL Server Management Studio, expand the Databases. You should be able to see the EventProData and EventProMaster databases, which you would have created in the previous step (Create New Client Database).

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

5.The Restore Database window appears.

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

a.The Select Backup Devices dialog 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, and which you saved to your computer.  

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

7.Back in the Restore Database dialog, under Destination, the Database should be set to EventProData.

8.Ensure that Source Device Database and Destination Database have been set correctly.

9.Under Select a Page in the left-hand panel, click Options. Select the Overwrite the Existing Database (WITH REPLACE) checkbox. (You want the restored, prepared database from EventPro Training/Support to overwrite the blank "placeholder" database that we created in the previous step.)

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

11.When the restore is complete, you should receive a dialog indicating "Database 'EventProData' restored successfully".  Click OK.

12.You can now proceed to Install EventPro.