Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fogcreek
Starting Member
3 Posts |
 Posted - 2006-11-29 : 16:09:35
|
| Fog Creek makes an application called FogBugz that often sits on top of fulltext-indexed SQL Server databases. Thus this post, copied from our discussion forum:http://our.fogbugz.com/default.asp?fogbugz.4.13359.0Steve Macdonald of Secure Transit alerted me to this situation:Microsoft has released Service Pack 1 for SQL Server 2005. SP1 (also known as SQL Server 2005 9.0.0.2047) allows mirrored databases, which is different from clustered. Transactions get updated on the mirror as they come in, within milliseconds. It's suitable for medium or light duty. The setup requires 3 SQL Servers: primary, mirror, and witness. Since you can connect a FogBugz installation to multiple databases, or multiple FogBugz installations to one database, mirroring sounds great for making your FogBugz bulletproof.But mirroring didn't work in this case. The failover setup and everything got set up fine, and then it crashed when Steve tried to actually switch from the primary to the mirror.As it turns out, this is a known issue with SP1. It affects only fulltext-indexed SQL Server databases, and FogBugz databases in SQL Server are fulltext-indexed, so if you try to make a failover environment for FogBugz it won't work with mirroring in SP1.However: there is a hotfix available. You have to call Microsoft support and they'll send you a password-protected zipped file and give you the password separately, etc., etc. If you apply the hotfix, Steve believes, it brings you to SQL Server 2005 9.0.0.2186.THEN you can have a mirrored implementation of a FogBugz database.This hotfix, Steve heard from MS, will be incorporated into Service Pack 2, but who knows when SP2 will come out?So, if the sweet redundancy of SQL Server mirroring gets your engine going, make sure you get SP1 *and* the hotfix. |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
|
|
|
|
|
|
Need hotfix to SP1 mirror fulltext-indexed DBs