How do I restore a full SQL Database backup?

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:

restore.jpg

 

4. Choose Device and browse to the database backup:

restore2.jpg

 

5. Select Options from the left of this pop-up screen and choose to "Overwrite the existing database (WITH REPLACE)" as shown below:

restore3.jpg

 

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.

Referenced by:

Have more questions? Submit a request

0 Comments

Article is closed for comments.