Welcome to

SqlServer-QA.net

Sign in | Join | Help

SQL Server 2008 features that work only in Enterprise Edition

One of the new features available in SQL Server 2008 is compressed backup which takes backup of a database with mimimum possible size. The syntax is

backup database db_name to disk='backup_path'
with init,
compression

But this works only in Enterprise Edition of the SQL Server 2008 and not in other editions

If you want to know the new features that only work in Enterprise Edition,refer this
http://msdn.microsoft.com/en-us/library/cc645993.aspx

Published Tuesday, November 03, 2009 11:18 AM by Madhivanan

Comments

# SQL Server Transact-SQL (SSQA.net) : SQL Server 2008 features that work only in Enterprise Edition

# SQL Server 2008 features that work only in Enterprise Edition

One of the new features available in SQL Server 2008 is compressed backup which takes backup of a database

Tuesday, November 03, 2009 6:22 AM by Other SQL Server Blogs around the Web

# SQL Server 2008 features that work only in Enterprise Edition

Kudos for a great Sql Server article - Trackback from SqlServerKudos

Tuesday, November 03, 2009 10:32 PM by SqlServerKudos
Anonymous comments are disabled