Transact-SQL




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

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

 


MarkiMarta.com. Notes of web-specialist
Since 2009
18+