Restore database in SQL Server Management Studio from Device

Step 1: Right click on Databases and select "Restore Database..."


Step 2: Select "From device" and then click on that button


Step 3: Select Add


Step 4: Select "Files of type" as "All Files(*)"


Step 5: Go to the database location and select that database. Then press Ok.


Step 6: Press Ok


Step 7:
  • Give the database name as you want to save the database. 
  • Mark the Restore box.
  • Press Ok.

Step 8: At the end, it will show successful message.

Comments

Post a Comment

Popular posts from this blog

Name of the button column in dataGridView

Image
Here I have two button column named Edit and Delete. To get the column's name, do the following steps.  Step 1:  Select the dataGridView and click on the arrow sign. Step 2:  Select the Edit Columns option. Step 3:  On the left side, a list of column's header will be shown of the dataGridView. To change the properties of Edit Column select Edit . On the right side, it's properties will be shown. The Name under Design section indicates the name of the Edit column. 
Read more