none
SQL Server Versions

    Question

  • Could somebody please advise me on the differene between the following two builds for SQL Server?

    10.50.1600

    10.00.1600

     Is 10.50.1600 same as 2008 R2? Has it been released?

    Thursday, June 03, 2010 4:56 PM

Answers

All replies

  • >> Is 10.50.1600 same as 2008 R2? Has it been released?

    Yes, 10.50.xxxx is SQL Server 2008 R2. You can download that here 

    http://www.microsoft.com/sqlserver/2008/en/us/R2Downloads.aspx


    http://SankarReddy.com/
    • Marked as answer by nabilas Friday, June 04, 2010 12:06 PM
    Thursday, June 03, 2010 5:20 PM
    Moderator
  • This blog article has the entire SQL server build levels and their corresponding versions released till date starting from SQL server 7.0

     

    http://sqlserverbuilds.blogspot.com/

     


    Thanks, Leks
    • Proposed as answer by Naomi N Monday, June 27, 2011 3:07 AM
    Thursday, June 03, 2010 9:10 PM
    Answerer
  • 10.00.xxxx is the SQL Server 2008 release and 10.50.xxxx as Sankar pointed out is the SQL Server 2008 R2 release. 2008 R2 has mainly BI related enhancements. The features can be found here http://www.microsoft.com/sqlserver/2008/en/us/R2.aspx


    This posting is provided "AS IS" with no warranties, and confers no rights.
    My Blog: http://troubleshootingsql.wordpress.com
    Twitter: @banerjeeamit
    SQL Server FAQ Blog on MSDN: http://blogs.msdn.com/sqlserverfaq
    Friday, June 04, 2010 12:00 AM
  • Hi,

    I have a question related to this thread.  I could not successfully restore a database backup in SQL 2008 R2 to my server which has SQL2008 Std. Edition.  Im getting an error message "REstored failed for server <myservername> (Microsoft.SQLserver.SMOExtended)"  Additional Information System.Data.SqlClient.SQlError:  The database was bcked up on a sever running version 10.50.1600.  That version is incompatible with this sever, which is running version 10.00.4064.  Either restore the database on a server that support tis backup or use the backup that is compatible with this server"

    Im also quite consfused as I have other customer databases on SQL2008 R2 and I am able to restore the database.  Do advise.

    Thanks.

     

    Monday, June 27, 2011 2:30 AM
  • You can not restore SQL Server 2008 R2 backup to a lower version (SQL Server 2008 (no R2)) It's a fact. The only way will be to script the whole database through Tasks/Generate Scripts. Unfortunately, no better way exists.
    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog
    Monday, June 27, 2011 3:08 AM