Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


SQL Server Full Backups


The most common types of SQL Server backups are complete or full backups, also known as database backups.  These backups create a complete backup of your database as well as part of the transaction log, so the database can be recovered. This allows for the simplest form of database restoration, since all of the contents are contained in one backup.


A full backup can be completed either using T-SQL or by using SSMS.  The following examples show you how to create a full backup.

Create full SQL Server database backup to one disk file


This will create a full backup of the AdventureWorks database and write the backup contents to file "C:\AdventureWorks.BAK".  The .BAK extension is commonly used for identifying that the backup is a full database backup.

BACKUP DATABASE AdventureWorks TO DISK = 'C:\AdventureWorks.BAK'

SQL Server Management Studio

  • Right click on the database name
  • Select Tasks > Backup
  • Select "Full" as the backup type
  • Select "Disk" as the destination
  • Click on "Add..." to add a backup file and type "C:\AdventureWorks.BAK" and click "OK"
  • Click "OK" again to create the backup
backup database with ssms

Here is what this looks like in SSMS 17.

backup database with ssms

Last Update: 2/22/2019

More SQL Server Solutions

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 

Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


Wednesday, February 14, 2018 - 9:01:06 AM - Pawan Back To Top

 hi ,

Take a example where recovery mode is in full and we change in between it to simple mode when the TR space is 50%(ex-32 GB) full.

What i have noticed is that the time you change the recovery mode , space goes to 0% full. so , what is happing with 32 GB data ?







Wednesday, April 20, 2016 - 3:24:07 PM - Amit yadav Back To Top

 thanks a lot :)

very helpfull article




Learn more about SQL Server tools