Rolling upgrade using database mirroring (and a bug in 2008 RTM)

While trawling through the latest 2008 Books Online this morning to answer a question, I noticed a new section that I hadn't seen before, which explains in detail how to perform a rolling upgrade with database mirroring. The link to the MSDN page is http://msdn.microsoft.com/en-us/library/bb677181.aspx and below I've linked to the flowchart from that page.   Books […]

Couple of nasty FILESTREAM bugs fixed in 2008 RTM CU1

Cumulative Update 1 for SQL 2008 RTM contains fixes for two nasty FILESTREAM bugs (among a lot of other bug fixes). The first one concerns restoring a 2008 database from a series of log backups when the database contains FILESTREAM info. It's possible that a race condition can cause one of the log backups to […]

SQL Server 2008 patching has begun – and the PSS blog

Just over a month since SQL Server 2008 went to RTM and the first Cumulative Update (CU1) has been released. Bob Ward, a very good friend of mine, and a Principal Escalation Engineer in the SQL Server Product Support team published a detailed blog post on Friday explaining how to get it and install it. […]

SQL Server 2008: On installing the latest CTP…

My previous post on Backup Compression reminded me to post about installing the latest SQL Server 2008 CTP (here’s a link to the download page). I’ve installed SQL Server 2008 many times, both within Microsoft and since leaving in August, but I’ve never done it on a system that has SQL Server 2000 installed too. […]