Using SQL Server Management Studio to configure the database

After you install both the SQL Server 2014 (or later) database and SQL Server Management Studio, you can restore the Frac Explorer database using the Management Studio. The database provides the required database schema for your completions data.

Two Frac Explorer components are available for download from the Kingdom Download page:

  • The Frac_Explorer_Database.bak file
  • The Frac Explorer Web Service

To restore Frac_Explorer_Database.bak:

  1. The downloaded Frac_Explorer_Database.bak file must be in a local directory on the web server computer. Copy the file to the server if necessary.
  2. Open the Management Studio: Start > All Programs > Microsoft SQL Server 2014 > SQL Server Management Studio
  3. Connect to the Management Studio with SQL Server Authentication as directed by your database administrator.
  4. Right-click on Databases and select Restore Database.
  5. In the Restore Database dialog box, select Device and click the Browse ... button.
  6. In the Select backup devices dialog box click Add.
  7. Browse to the .bak file in the local directory , select it, and click OK.
  8. Click OK to exit the Select backup devices dialog box.
  9. In the Restore Database dialog box select Options on the left.
  10. Under Restore optionsselect the Overwrite option. You can also use this option if you are restoring the database for the first time..

You are done. Expand the database node and then the Tables node to see the list of tables in the database.