Wednesday, 14 December 2016

Backups and Compression:

-- Normal Backup performed on the Database
BACKUP DATABASE [AdventureWorks2016] TO DISK 
= 'C:\Backup\DbName_uncompressed.bak' WITH STATS = 10, NO_COMPRESSION, FORMAT;
GO
-- Normal Backup (with Compression enabled) performed on the Database
BACKUP DATABASE [AdventureWorks2016] TO DISK 
= 'C:\Backup\DbName_compressed.bak' WITH STATS = 10, COMPRESSION, FORMAT;
GO

No comments:

Post a Comment