Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
SQL Server Versions

Answered SQL Server Versions

  • Thursday, June 03, 2010 4:56 PM
     
     
    Sign In to Vote
    0

    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?

     

All Replies

  • Thursday, June 03, 2010 5:20 PM
    Moderator
     
     Answered
    Sign In to Vote
    0

    >> 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 9:10 PM
    Answerer
     
     Proposed
    Sign In to Vote
    0

    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
     
  • Friday, June 04, 2010 12:00 AM
     
     
    Sign In to Vote
    0

    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
     
  • Monday, June 27, 2011 2:30 AM
     
     
    Sign In to Vote
    0

    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 3:08 AM
     
     
    Sign In to Vote
    0
    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