When I want to restore a Microsoft SQL Server database, I take the following steps:

  • Copy the *.bak file to a local folder on the databaserver, like [C:\Temp]
  • Open Microsoft SQL Server Management Studio and connect to the Microsoft SQL Server Instance, you want the database restored to
  • Kill all processes that are connecting to the database, you want to restore. In the Object Explorer:
    • Expand [Management]
    • Right click [Activity Monitor]
    • Click [View Processes]
    • Right click a process
    • Click [Kill Process]
  • To restore the backup (*.bak) file, in the Object Explorer:
    • Right click [Databases]
    • Click [Restore Database…]
    • Select the database, you whish to restore or type in a new database name
    • Click [From device]
    • Click [Add]
    • Select you’re database file and click [OK]
    • Check the column [Restore]
    • Click [Options]
    • Check Overwrite the existing database
    • Change the [Restore As] locations
  • Right click Databases > Restore Database

 

Screendumps

image

image

 

image

 

image

 

image

 

image

 

image

image

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.