How To Create SQL Server Full Database Backup
Step-1: Open SQL Server Management Studio and connect to the SQL server by clicking on Connect button as shown in the following figure.
Step-2: Expand Databases by clicking on + icon in Object Explorer.
Step-3: Right-click on the AdventureWorks2014 database, Select Tasks and then click on Back Up as shown in the image below.
Step-4: On the Back-Up Database window, make sure the Database field contains the name of the database (AdventureWorks2014) you want to back up and from the Backup Type, select Full.
Step-5: Then click on Add… button to Add the Destination where you want to back up your database.
Step-6: From the Backup Destination Window, click on three dots[…] to change the destination, A new window will open, then select the folder and type the backup name as shown in the below image and click on OK button.
Step-7: Click on Ok button
Step-8: Click on Media Options from left pane and check the Overwrite all existing backup sets radio button and click on OK button.
Step-9: Database backup will be completed and a popup window will appear with a message “The backup of database AdventureWorks2014 completed successfully”, and then click on OK button.
