Difference between SQL Server 2008 Standard and R2 editions

Question

Hi all,

     Can anyone tell me whats the difference between Standard edition of SQL Server 2008 and R2 edition of SQL Server 2008. Recently one of my database which was in SQL Server 2008 R2 express eiditon I could not restore it to SQL Server 2008 Standard edition. I have to install new instance of SQL Server 2008 R2 Express edition. I want to know the difference between these two editions.

Thanks in advance,

 

Nilkanth Desai

 

Answer 1

SQL Server 2008 R2 is a new release of SQL Server, not an edition. SQL Server 2008 R2 includes new versions of all of the SQL Server editions, from Express up to Datacenter.

To see the lists of new features released in SQL Server 2008 R2, see http://msdn.microsoft.com/en-us/library/bb500435.aspx. If you are using Express, you can just go straight to the Database Engine What's New topics at http://msdn.microsoft.com/en-us/library/bb510411.aspx.

For SQL Server 2008 R2 backward compatibility issues, see http://msdn.microsoft.com/en-us/library/cc280407.aspx.

---

Alan Brewer [MSFT] SQL Server Documentation Team This posting is provided "AS IS" with no warranties, and confers no rights.