Posts

Showing posts from November, 2020

Backup database in SQL Server Management Studio

Image
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.