Sql server支持压缩备份吗？ [英] Sql server supports compression for backup?

问题描述

我想找到sql server是否支持使用vb.net进行备份压缩。



我尝试过：



我尝试了以下代码

I want to find if the sql server supports compression for backup using vb.net.

What I have tried:

I tried the following code

BACKUP DATABASE KGMERP_SHANTHI To DISK = 'F:\KGM\ManualBackup\SHANTHI_KGM_07-09-2018 18 48 24 SQL_2012 Express Edition.bak' WITH  NOFORMAT, NOINIT, NAME = 'KGMERP_SHANTHI', SKIP, COMPRESSION

它支持2012企业版，不适用于快递版。

It supports on 2012 enterprise edition and not works on express edition.

推荐答案

无法找到SQL 2012的信息



2016版本比较图表（下面链接）显示只有标准版和企业版支持备份压缩; Web，Express和Express Advanced版本不支持
SQL Server 2016的版本和支持的功能Microsoft Docs [ ^ ]

Could not find that information for SQL 2012

The 2016 version comparison chart (linked below) shows that Backup Compression is only supported on the Standard and Enterprise versions; the Web, Express, and Express Advanced versions do not
Editions and supported features of SQL Server 2016 | Microsoft Docs[^]

这篇关于Sql server支持压缩备份吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！