Prev: Mirror error message
Next: Not able to backup database to different folder
From: Robyn H on 16 Jun 2010 17:29
We currently have SQL Standard 2008 in a 2 node cluster and are
investigating perhaps updating to R2.

Does anyone know where I could find a comparison that would give us the
benefits of this update?
From: Erland Sommarskog on 17 Jun 2010 17:38
Robyn H (robyn.harcott(a)ufv.ca) writes:
> We currently have SQL Standard 2008 in a 2 node cluster and are
> investigating perhaps updating to R2.
>
> Does anyone know where I could find a comparison that would give us the
> benefits of this update?

What parts of SQL Server do you use? Most of the new stuff is on the BI
side, and there are very few changes in the Database Engine. But since
you are on Standard Edition, there is one tidbit: backup compression
is now available in Standard Edition.

If you are using Reporting Services, I believe there is a substanial
set of changes. Not so much in Integration Services or Analysis Services.

Here is a marketing page with some information:
http://www.microsoft.com/sqlserver/2008/en/us/R2-editions.aspx

And here is the gory information from Books Online:
http://msdn.microsoft.com/en-us/library/bb500435.aspx



--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 | 
Pages: 1
Prev: Mirror error message
Next: Not able to backup database to different folder