Thursday, June 03, 2010 4:56 PM
Could somebody please advise me on the differene between the following two builds for SQL Server?
Is 10.50.1600 same as 2008 R2? Has it been released?
Thursday, June 03, 2010 5:20 PMModerator
>> 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
- Marked As Answer by nabilas Friday, June 04, 2010 12:06 PM
Thursday, June 03, 2010 9:10 PMAnswerer
This blog article has the entire SQL server build levels and their corresponding versions released till date starting from SQL server 7.0
- Proposed As Answer by Naomi NMicrosoft Community Contributor Monday, June 27, 2011 3:07 AM
Friday, June 04, 2010 12:00 AM
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
SQL Server FAQ Blog on MSDN: http://blogs.msdn.com/sqlserverfaq
Monday, June 27, 2011 2:30 AM
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.
Monday, June 27, 2011 3:08 AMYou 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