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

This article shows you how to do database compression full backup through script in sql server, the content is concise and easy to understand, it can definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Solution:

Explicitly enable backup compression through with compression, specify that backup compression be performed on this backup, and override the server-level default settings. For SQL Server 2008 and later.

Because compressed backups of the same data are smaller than uncompressed backups, compressed backups usually require less device Istroke O, which can usually greatly improve backup speed.

Script:

Backup database DbName to disk ='D:\ DbName.bak'-full with compression;-compressed backup go the above is how to do database compressed full backup through script in sql server. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

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.