How to make SQL Server Full Backup

How to make SQL Server Full Backup

Overview
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.


Explanation
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
T-SQL
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.
BACKUPDATABASE AdventureWorks TODISK='C:\AdventureWorks.BAK'GO

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

Here is what this looks like in SSMS 17.

Last Update: 2/22/2019


Source: mssqltips.com

    • Related Articles

    • How To Protect Yourself From Phishing Attacks

      Your email spam filters may keep many phishing emails out of your inbox. But scammers are always trying to outsmart spam filters, so it’s a good idea to add extra layers of protection. Here are four steps you can take today to protect yourself from ...

    • What To Do if You Were Scammed

      Find out what to do if you paid someone you think is a scammer, or if you gave a scammer your personal information or access to your computer or phone. Scammers can be very convincing. They call, email, and send us text messages trying to get our ...