SQL Server 2008备份压缩标准版 [英] SQL Server 2008 Backup Compression Standard Edition

问题描述

我尝试在SQL Server 2008中备份数据库，并使用新的压缩功能压缩数据库。然而，当我运行下面的代码，我得到一个奇怪的错误信息：

 备份数据库<到磁盘'C：\Backup'压缩
  

我收到此错误消息：

标准版不支持压缩备份数据库

这是否意味着我必须升级到完整版或是否有在标准版中启用压缩的方法？

解决方案

备份SQL 2008 Express，Workgroup或Standard版本不支持压缩，仅在Enterprise上。没有办法在没有将您的版本升级到Enterprise的情况下启用此功能。

虽然您无法在这些版本上进行压缩备份，但可以从压缩备份进行RESTORE。 / p>

请参阅 http：/ /technet.microsoft.com/en-us/library/bb964719.aspx 了解详情。

I'm trying to backup a database in SQL Server 2008 and have the database compressed using the new compression feature. However, when I run the following code, I get a weird error message:

Backup Database <Database> To Disk 'C:\Backup' With Compression

I get this error message:

Backup Database With Compression is not supported on Standard Edition

Does this mean I have to upgrade to the full version or is there a way to enable compression in standard edition?

解决方案

Backup Compression is not supported on SQL 2008 Express, Workgroup, or Standard editions, only on Enterprise. There is no way to turn this on without upgrading your version to Enterprise.

Although you can't backup with compression on those versions, you can RESTORE from compressed backups.

See http://technet.microsoft.com/en-us/library/bb964719.aspx for more info.

这篇关于SQL Server 2008备份压缩标准版的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！