Coupon code copied
Server Intellect
(855) 850-HOST

Toll Free 24/7/365        (4678)

Get help from a Microsoft Certified Engineer.

Intellect Connect

Technical problem with your Windows Hosting?

Let our Microsoft Certified experts handle the problem for you.

Restore Database using Management Studio Express

First, navigate to Start -> Programs -> Microsoft SQL Server 2005 -> SQL Server Management Studio Express

Step 1

Upon opening the program, you should be prompted with a Connect to Server box. Fill out the fields with your database information.


Step 2

The Server Name field is the IP of the Database Server. You also must include ‘,2433’ after the IP to specify port ‘2433’.

The Authentication field should be SQL Server Authentication by default.

The Login field is the username you have set up for the database.

The ‘Password’ field is the password you have set up for the user.

Upon connecting, you will see a window similar to the picture below. On the left, select/expand Databases and find your Database name.


Step 3

Right click on your database and go to Tasks -> Restore -> Database


Having Problems with Windows Server?

Try our troubleshooting service

  • Microsoft Certified Engineers
  • Remote Log-in to Your Servers
  • End-to-End Troubleshooting

Our Certified Technicians have been supporting Microsoft® products for well over a decade.

Tell us where you are getting stuck

Get Help Now!

Having Trouble Solving This Problem?

Let our Microsoft® Certified Engineers fix it for you.
Just $50.00 one time fee.

Having Trouble Implementing This Solution?

Why not let our Microsoft® Certified Engineers do it for you.
Just $50.00 one time fee.

Request Immediate Expert Help

Step 4

Select From device and click the small grey box on the right labeled . A window will pop up, Click Add and browse to the location of your .bak file. Click OK.

Check the checkbox under the column Restore next to the database information in the bottom pane.

Go to the Options (top-left).

Check Overwrite the existing database.


Step 5

Click OK to begin the database restoration.

Now that your database is restored, we have to make sure the users associated with the database have proper permissions.

Collapse the Databases directory in the left window. Expand the Security folder and go to Logins and find the Username associated with the database. Right click on the Username and go to Properties.


Step 6

Go to the User Mapping on the top-left. Locate your database in top-right window pane list and make sure the checkbox is checked next to it. Once the database is selected, make sure the db_owner checkbox is checked in the bottom window pane and click OK.


If this has completed with No Errors then you have successfully restored your database!

Interested in letting our experts solve your IT problems for you?
Get a free, no-obligations consultation with one of our experts today!

Call us at (855) 850-HOST


Start Your Order


This form does not accept free e-mail accounts. Please enter a business e-mail to submit it.

Submit Form Cancel

Please wait...

Submitting your info. This may take less than a minute.