How to restore .BAK file using SQL Server 2008

Asked By Husna 40 points N/A Posted on - 10/03/2012

I have a database file which is developed in SQL server 2008, but i have only backup file of that database. Now i want to run that file please tell me how can i restore that file.

• Status: Open
• Question Views: 1222
• Answer Count: 2
• Vote Up 2 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by Nelson pruitt

Go To Solution

Best Answer

Best Answer

Answered By Nelson pruitt 0 points N/A #160804

How to restore .BAK file using SQL Server 2008

 

This is a little bit complicated. I'm using Microsoft SQL 2005, but I was able to find a link that will answer your question. I hope this will help you out. https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-database-backup-using-ssms Just follow each step carefully and you will be able to restore your backup without any problems.

-Nelson

About Nelson pruitt

Questions
1

Answers
20

Best Answers
9

• Vote Up 0 Vote Down

• Posted on - 10/03/2012
• Question Category: MS SQL Server

Answered By Emil Onoon 0 points N/A #160806

How to restore .BAK file using SQL Server 2008

First open SQL Server 2008 and authenticate. Then in the left pane i.e. Object Explorer, right click on Databases. From the contextual menu click on Restore Database. A new window will pop-up. Enter the name of the database in the To Database field. Now choose From Device below and proceed. Now it will ask you to specify Backup. Click on Add. Now locate the backup file from your computer and click ok. Select it from the checkbox and it will be restored.

See the attached images.

About Emil Onoon

Questions
0

Answers
198

Best Answers
58

• Vote Up 0 Vote Down

• Posted on - 10/16/2012
• Question Category: MS SQL Server