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…
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…
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…