In order to restore your database to your SQL Server, you will need SQL Server Management Studio. To download a copy of the 2014 Express version, please click here for the download link.
On the download screen, scroll down and select the option for: MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe. Once you have installed SQL Server Management Studio, you can continue on to the next steps:
1. Put the copy of your database in an easy to reach location on the SQL Server (Eg. root of the C drive)
2. Connect to the SQL Server using SQL Server Management Studio
3. Right-Click on the database that you want to restore over top of:
4. Choose Device and browse to the database backup:
5. Select Options from the left of this pop-up screen and choose to "Overwrite the existing database (WITH REPLACE)" as shown below:
6. Click 'Ok' and once the restore completes, you should see a successful message.
7. Assign the Intranetconnections user to this database by right-clicking on the database > select new query > paste the following script into the box provided:
exec sp_change_users_login 'auto_fix','intranetconnections';
8.Click Execute to run the script.
Note: If you have restored this database on a new server, you will need to create and assign the 'intranetconnections' user to the database. To learn how, click here.