[There's a reason that Yoda is the unofficial mascot of SBS.  Size indeed matters not.] Installing SQL 2005 sp2 - THE OFFICIAL BLOG OF THE SBS "DIVA"
Fri, Jun 1 2007 21:38 bradley

Installing SQL 2005 sp2

Tonight we're going for SQL 2005 sp2.  Remember on this one we need three parts...

SQL 2005 SP2 - from Microsoft update (reboot)

And then the next part from Microsoft update
FIX: The Check Database Integrity task and the Execute T-SQL Statement task in a maintenance plan may lose database context in certain circumstances in SQL Server 2005 builds 3042 through 3053:
http://support.microsoft.com/kb/934458/en-us (no reboot)

And then you need this hotfix:
FIX: Event ID: 1 may be logged when you use a Volume Shadow Copy Service (VSS) writer to back up a snapshot in SQL Server 2005:
http://support.microsoft.com/default.aspx?scid=kb;en-us;934396

Filed under: