SQL Database Backup using SQL Server Management Studio

In this post we will learn how to backup a SQL Database using SQL Server Management Studio

Steps:

1. Download and install the correct version of the Management Studio Link

2. Launch Management Studio and login with the correct credentials

3. Navigate to Databases and Right Click on the Database to backup
4. Select Tasks -> Backup

5. This should open up the Database Backup Settings window as shown below

6. Select the Backup type : Full, Differential or Transaction Log 

7. Now click on Add and chose the desired location for the backup. Click Ok  to start the Backup process