.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Sandeep Singh

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Restore bak file in sql server

Posted By:Maverick       Posted Date: May 17, 2011    Points: 200    Category: DataBase    URL: http://www.dotnetspark.com  

In this articles will see see how to Restore bak file in sql server step by step.

Restore the database.

  1. Copy the backup file from source server to destination server. I've copied into the same directory as source server.
    The backup file
  2. Connect to destination server. Open Microsoft SQL Server Management Studio Express and connect to server.
  3. Right-click on Databases. Select Restore Database.
  4. Restore Database window appears. On Source for restore, select From device and click browse buttton to browse file.
  5. On Specify Backup, ensure that Backup media is "File" and click Add.
    Select the backup media to restore
  6. On Locate Backup File, select the backup file. This is the backup file that was created in Backup a database section and was copied to this server. Click OK. OK.
  7. Back to Restore Database window.
    1. On Destination for restore, select "AdventureWorks".
      Note: If you haven't added the backup file on Source before (step 4-6), you won't see the database name on Destination.
    2. On Source for restore, check the box in front of the backup name (in Restore column).
    3. Click OK.

  1. Wait until restore finish and there'll be a pop-up message notify.
    Restore success pop-up message
  2. Now you'll see the restored database on the destination SQL Server.

 Subscribe to Articles


Further Readings:


No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend