Backup MSSQL database with compression

To create a full backup of MS SQL Server database with compression use this SQL command:

use YourDataBaseName
go

BACKUP DATABASE YourDataBaseName
TO DISK = 'Z:\BACKUP_FILE_NAME.bak'
WITH COMPRESSION

use YourDataBaseName

BACKUP DATABASE YourDataBaseName

TO DISK = 'Z:\BACKUP_FILE_NAME.bak'

WITH COMPRESSION

According to database size and your server capabilities, backup time can vary.