In the recent times Microsoft Release Services adopted the 935897 Incremental Servicing Model (ISM) for SQL Server team to deliver hotfixes for reported problems, also the new 822499 naming schema for Microsoft SQL Server software update packages.

In this regard here is the 10th instalment of Cumulative Update package for SQL Server 2008, so when you apply the fixes the build of the cumulative update package is also known as build 10.00.1835.00. A note of caution on backout plan if there is any problem reported on post installation that you must test thoroughly all the builds agains your applications. Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 fix release.

Similar to the build and configuration options, one of the client have had issues surrounding dataloss within Database Mirroring automatic failover/failback options and aborted distributed transactions, as usual the support case with Microsoft suggested the lastest build SP1 for SQL Server 2008 and a glance about KBA search revealed that this CU10 build includes the bugs that were reported.As this is a hotfix the fix is not available for public download, KBA refers about:

How to obtain Cumulative Update 10 for SQL Server 2008

loadTOCNode(2, 'moreinformation'); A supported cumulative update package is now available from Microsoft. However, it is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems. This cumulative update package may receive additional testing. Therefore, if you are not severely affected by any of these problems, we recommend that you wait for the next SQL Server 2008 service pack that contains the hotfixes in this cumulative update package.

If the cumulative update is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.

Note If additional issues occur or any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific cumulative update package. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

Again I refer KBA 956909 which gives you SQL Server 2008 builds that were released after SQL Server 2008 was released.