List of Fixes in SQL Server 2008 R2 SP3

Service Pack 3 contains all the fixes from 2 years worth of Cumulative Updates, as well as two additional fixes.  Here is a complete list of the fixes provided in SP3 along with the CU that they originally came from.   Added to SP3   VSTS Bug KB article number Description Fix area 2976923 2994310…

2

Recovering from Log File Corruption

I was with a customer this week how had experienced an issue with their server, and it left them with a corrupt transaction log.  Obviously I can’t and won’t go into detail about who it was and the specifics of how it happened, but this customer experienced a hardware issue and some faulty memory, which…

2

Best Practise for Patching SQL Server

Patching SQL Server is a topic I get questions about a lot, so I thought it would be a good idea to write a post about it so that I could try and answer all those questions in 1 place.     Where can I find out what the latest patch level is for SQL Server…

14