In this article we will see steps for taking backup of SQL Server database
Step 1. Connect to database server using SQL Server Management Studio
Step 2. Right click on the database and select Tasks , then select ‘Back up’
Below screen will appear:
Now click on Remove button if it shows some existing backup file like above. Now click on Add button. Below screen will appear. Click on highlighted button to select backup location:
Provide a file name as shown below. Please note file extension should be ‘.bak’
Click on OK button, below screen will appear.
Click on OK button, now backup process will start and create backup file at selected location