Hello. Thanks for visiting.

Have questions about Server Intellect?

I'm here to help.

Call us toll free at 1-855-850-HOST(4678)

Server Intellect
(855) 850-HOST

Toll Free 24/7/365        (4678)

Everything is going to be okay. We can solve your issues.

Intellect Connect

Technical problem with your Windows Hosting?

Let our Microsoft Certified experts handle the problem for you.
Chat Now

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.

kb-sql-restore-db-1

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.

kb-sql-restore-db-2

Step 3

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

kb-sql-restore-db-3

Let Us Fix it For You

Solution Includes

  • Painless Support App
  • Remote Server Management
  • Fast Issue Resolution

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

Fill out the form below to get started

Get Started

Tired of Googling for Answers?

Our Microsoft® Certified Technicians can fix your problem for you.
Give us a try.

Learn More

Can't Find Your Solution?

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

Get Started

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.

kb-sql-restore-db-4

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.

kb-sql-restore-db-5

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.

kb-sql-restore-db-6

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

Chat Now

Start Your Order

X

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.