SQL Server Database Backup

DB backup is very easy in SQL Server as it can be done even from GUI. 
You have to just run through a wizard and this creates DB backup. 

Step 1: For taking backup just right click on your DB and go to tasks and select Backup as shown in screen below. Now, you will be presented with window with two tabs viz. General and Options.

Step 2: For general tab select following set properties.

• Database = Sample

• Backup Type = Full

• Backup Component = Database 
• Backup Set 
• Name= Sample-Full Database backup 
•  Description: Demo Backup 
• Backup set will Expire: After, 0 Days (Means it never expires) 

• DestinatioN
•  Backup to: Disk 
• Add: D:\Sample.bak

• Extension will be

•  .bak = for Full & Differential Backup Types.
• .trn 

Step 3:  For options tab set following properties.

• Overwrite media 

•  Append to existing media set. (In case you want this backup to be attached to existing one in same file.)

•   Reliability:

• Verify backup when finished. (This will temporarily restore backup to verify) 
•  Perform checksum before writing to media. 

•  Compression

• Set Backup Compression: Do not compress backup