Restoring SQL 2008 server database backup

Have you ever moved offices, come to switch your VM SQL server on and found that the SQL server image doesn’t even exist? I have. Lucky that I took a backup hey?

 

Here is how to restore an SQL server backup:-

 

1. Log on to Microsoft SQL Server Management Studio with an account that has the right permissions.

2. Go to “Databases”, right click “New Database”

3. Name the DB the same as it was before. This should be in the name of the backup

4. Navigate to the DB, right click – tasks – restore – Database.

5. Choose “From Device” and navigate to the location of the backup.

6. In the “Select the backup sets to restore” section tick the box under “Restore”.

7. Go to “Options” and tick the box that says “Overwrite the existing database (WITH REPLACE)”

8. Click OK

 

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s