To create a full database backup using Transact-SQL
Execute the BACKUP DATABASE statement to create the full database backup, specifying:
- The name of the database to back up.
- The backup device where the full database backup is written.
Example
BACKUP DATABASE
AdventureWorks
TO DISK =
'C:BackupsAdventureWorks.BAK'