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.