How to take database full backup in SQL server ?

To take the full backup of a database , I recommend you to follow the below steps.

Step 1:

Right click the database which you want to take backup.In below screenshot I am going to take backup of StudentForm database.

select database --> Right Click --> Tasks --> Back up

Step 2:

After selecting the Backup option, backup database window will appear, you can change the database in source option as shown below.

Step 3:

After selecting the required database ,choose the FULL backup type  as shown below.

Step 4:

You can set the expiry date for the database backup by using the backup set option as shown below.

The default backup path for the database will be C drive (i.e. SQL server installed drive)

To change destination path , select and click remove button as shown above.

Step 5:

After removing the path click add button.Then the select backup destination pop up window will appear as shown below.

Select the button which is highlighted in Red colour as shown above.

Step 6:

Now locate database files window will appear.

Here choose the required path and enter the backup file name in file name text box as shown below.

Finally do not forget to add the extension (.bak) in backup file name and then click OK button.

Step 7:

Now you can notice that the backup path has been changed as shown below.

Then click OK button.

Step 8:

After some moments (Restoring time depends on database size) you can see the pop up window as shown below.

Now the database backup is completed.

Step 9:

You can see the database backup in the given destination path as shown below.