Whilst trying to restore a “master” backup file (on my Windows Server 2003 / SQL 2005) machine I’ve dropped a clanger and re set the number of users from “0” (unlimited) to “1” in the SQL enterprise manager console (ignoring the warning that enterprise manager gave me about no longer being able to use the management console if I did this !).

Can anyone explain how to reverse this ?. I’m sort of expecting that It will have to be done from a command prompt somehow ?.

I have an Identical twin “standby” Proliant ML350 as a backup for a Sage enterprise system. I periodically backup the Sql databases from Sage and restore them to my standby machine. This has worked well for years – but you do have to restore the “master” databases whilst in single user mode. In a moment of stupidity I thought I’d try doing this by altering the setting mentioned above rather than my usual method.