Fog Creek Software
Discussion Board




Win2003/MSSQL oddity re: "single use database"

At least 2 of the last several Sundays, our FB database has gone into "single user" mode.

To see what I mean, right click the db in enterprise manager and click Properties, then click the Options tab.

At the top of the tab is a section called "Access", which contains a checkbox that says "restrict access".

Normally, this box is unchecked. Twice now I have logged in on a weekend to find this box checked and the radio button for single use has been selected.

No one else here in the office has a clue about these settings, much less what or where enterprise manager is (no, Im not kidding, there are no other programmers or database geeks here).

Anyone have an idea what would cause this?

TIA,

Mark

Mark Riffey
Monday, March 15, 2004

I may be going out on a limb, but I'm guessing FTS may not be set up correctly in SQL Server, Fogbugz_FTE fails, and your database reverts to it's default setting for access restrictions, single user mode.

To determine if the database is enabled for full-text search, use this query:

SELECT DATABASEPROPERTY('fogbugz','IsFulltextEnabled')

Fogbugz_FTE is a scheduled job in SQL Server that updates the full text catalog on the BugEvent table:
http://www.fogcreek.com/FogBUGZ/KB/dbsetup/FTScatalog.html

You could take a look at our guide for FTS troubleshooting if needed:
http://www.fogcreek.com/FogBUGZ/KB/dbsetup/FullTextSearch.html

And Microsoft's comprenhensive guide to setting up FTS is:
http://support.microsoft.com/default.aspx?scid=kb;en-us;323739

Dmitri
Fog Creek Software
Monday, March 15, 2004

Thanks Dimitri:)

It looks like the job is running fine here (via Agent) but the tab you referred to was empty, so I have some investigation to do.

Mark

Mark Riffey
Monday, March 15, 2004

Mark,

Do you have a maintenance plan setup for the FB database? I was running into this same issue on Win 2K machine. I finally had to disable the maintenance plan and now do backups manually to keep the db from going into single user mode :(

Zack

Zack Jones
Monday, March 22, 2004

*  Recent Topics

*  Fog Creek Home