Procedure for Backup of Sql Databases

Backup of Database:


Step 1: Right on the Database for i.e Test - > All Tasks -> Backup



Step 2: when clicked on Backup Database, the below will open, if you want Remove the Existing path , and click on “Add” button



Step 3: when clicked on add button, the below window will open, and click on the highlighted button.



Step 4: After clicking the highlighted button, the below window will open, select the location for saving the file and give the file name i.e. Test, click on ok



Step 5: the below window open, and click on OK button.



Step 6: after clicking on OK button, the below window will open, then click on ok



Step 7: after clicking on ok, the below window will open, saying that “back up operation has been completed successfully”, you can find the file in the specified location.