Backups and Compression:
-- Normal Backup performed on the DatabaseBACKUP DATABASE [AdventureWorks2016] TO DISK = 'C:\Backup\DbName_uncompressed.bak' WITH STATS = 10, NO_COMPRESSION, FORMAT;GO-- Normal Backup (with Compression enabled) performed on the DatabaseBACKUP DATABASE [AdventureWorks2016] TO DISK = 'C:\Backup\DbName_compressed.bak' WITH STATS = 10, COMPRESSION, FORMAT;GO
No comments:
Post a Comment