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.
BACKUP DATABASE AdventureWorks TO DISK = 'C:\AdventureWorks.BAK' GO