Databases, Microsoft SQL Server

Backup SQL Server Database

To create a Full Database Backup using transact sql is simple.
The following sql code does the trick:

USE database_name;
GO
BACKUP DATABASE database_name
TO DISK = ‘D:DatabaseBackupsdatabase_name.bak’
WITH FORMAT,
MEDIANAME = ‘D_Backups’,
NAME = ‘Full Backup of database_name‘;
GO