How to Backup MS SQL Database

In today's article I will show you how you can take backup of the MS SQL server database. So here are the steps to take the backup of the database in MS SQL server database. Here we will use SQL server management studio (SSMS). The given steps you can use to backup SQL Server 2019 (or 2022, 2017, 2016, etc.).

Step 1:

Connect to your MS SQL server database. 

Step 2:

Select the database and select option Task as shown below. Ones we select the task we another right menu will open in this menu we need to select the option Backup. So, the path will be Database -> Task -> Backup.

On selection of Task option below mention menu will open. In this menu you need to look for Backup.

Step 3: 

On click of backup option from above mention menu. You will get the below mention screen.

Here in above screen shot check the mention point 1,2,3. Here in point 1 the database is mentioned for which we want to create a backup. In point 2 you need to select the option Full This will define to take backup of all tables and data in it. In point 3 we need to define the path where we want to store the backup or want to save the backup of the database. In you want to change the path you can add a new path by clicking on "Add" button. Here you can mention your backup path.

Step 4:

Click on Ok button to start the backup. Ones you click on Ok button backup will start and on the given path. Ones the backup process is completed, you will get the backup completion message.

Now we have done. We can check the backup file on the mention path during the process. 

The MS SQS server backup file extension is .bak.