Backup database in SQL Server Management Studio

Step 1: 

  • Open SQL Server Management Studio > Databases
  • Select the database (I select StudentDB database)
  • Right click on the database
  • Select Tasks > Back Up.

Step 2: Remove the "By default" destination path. 

Step 3: Press Add to set the destination path.

Step 4: Press the button to select destination path.

Step 5:

  • Select your destination path. I select K drive > CodePointProgramming folder.
  • Set the File name. It is a good practice to add current date with the database name while taking backup. For example: StudentDB_27112020

Step 6: Press "Ok"

Step 7: Press "Ok".

Step 8: At last it will show a success 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