First, navigate to Start
-> Microsoft SQL Server 2005
-> SQL Server Management Studio Express
Upon opening the program, you should be prompted with a Connect to Server
box. Fill out the fields with your database information.
The Server Name
field is the IP of the Database Server. You also must include ‘,2433′ after the IP to specify port ’2433′.
field should be SQL Server Authentication
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.
Right click on your database and go to Tasks
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
Check Overwrite the existing database
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
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!