How to restore .BAK file using SQL Server 2008

Asked By 40 points N/A Posted on -
qa-featured

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.

SHARE
Best Answer by Nelson pruitt
Best Answer
Best Answer
Answered By 0 points N/A #160804

How to restore .BAK file using SQL Server 2008

qa-featured

 

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. http://msdn.microsoft.com/en-us/library/ms177429.aspx Just follow each step carefully and you will be able to restore your backup without any problems.

-Nelson

Answered By 0 points N/A #160806

How to restore .BAK file using SQL Server 2008

qa-featured

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.

Login/Register to Answer

Related Questions