SQL Server 2008: Does my database contain Enterprise-only features?

home
database
view story

2 Kicks

SQL Server 2008: Does my database contain Enterprise-only features?(sqlskills.com)

submitted by wisemx(8074) 3 years, 9 months ago

Moving databases around is pretty common, as is moving databases between servers running different Editions of SQL Server, especially during a disaster recovery situation. You may not know this, but in SQL Server 2005, if you had partitioning anywhere in a database, you could only attach/restore that database using an Enterprise or Developer instance. I say 'you may not know this' because partitioning isn't really widely used (from what I can gather from talking to customers). The upshot of this is that SQL Server 2005 will refuse to attach/restore a database with partitioning in - even if you're in a disaster recovery situation and the only server you have available has Standard Edition. In SQL Server 2008, a lot more people are going to bump into this issue. The list of features that are Enterprise only, and will prevent attach/restore using a lower edition has expanded to include 3 new features that WILL be much more commonly used than partitioning. The four features that are in this category are: Data compression Partitioning Transparent data encryption Change data capture

add a comment |category: Database |Views: 6
Tweet