Database Backup

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

Leave a Comment

Your email address will not be published. Required fields are marked *