Shulou(Shulou.com)05/31 Report--

Server through the script for database compression full backup method is what, I believe many inexperienced people are helpless, for this reason this article summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

Question:

Production databases can be large, and backup sets can consume a lot of disk space if they are fully backed up without compression. It brings inconvenience to the storage management of backup files.

Solution:

Explicitly enable backup compression with compression, specifying that backup compression be performed on this backup, overriding server-level defaults. Available for SQL Server 2008 and later.

Because compressed backups of the same data are smaller than uncompressed backups, compressed backups typically require less device I/O, and therefore typically significantly faster backups.

Script:

/* Description: Manually modify the DB Name and the Path and File Name to be backed up to, and then execute the script Source: www.cnblogs.com/zhang502219048/p/11062589.html*/backup database DbName to disk = 'D:\DbName.bak' --full backup with compression; --compressed backup go After reading the above contents, do you know how to perform database compression full backup by server through script? If you still want to learn more skills or want to know more related content, welcome to pay attention to the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.