Skip to main content
InSource Solutions

TN PT116 How to Backup a SQL Server Database

  1. Last updated
  2. Save as PDF

InSource_Logo_Transparent.png

Description

 

This article from InSource shows...How to backup a SQL Server Database

  • Author: Mike Viteri
  • Published: 05/20/2016
  • Applies to: Microsoft SQL Server

Details

1. Open SQL Server Management Studio

sql1.JPG

2. Select connect when the menu comes up

sql2.JPG

3. Expand your databases folder and select the database you want to backup. Right click on the database and select backup.

sql3.JPG

4. You can take the default path that comes up. You can also remove this path by clicking "Remove" Then click add to add your own path for your backup file. You can take the default for the rest of the settings.

sql4.JPG

5. Click ok. Now your database will be backed up. 

sql5.jpeg

6. Browse to the location of the backup and you will find your backup file.

sql6.jpeg