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.