Re: SQL Server pulls incorrect instance data from the registry?

Tech-Archive recommends: Fix windows errors by optimizing your registry

At least one of them had to be a named instance or both. Sounds like the
system wasn't configured correctly to begin with.

However, if you are having disk problems, then there could have been
corruption in the QUORUM which may have corrupted the registry replication
process.

For default instances, the parameters are stored in
HKLM\SOFTWARE\Microsoft\MSSQLSERVER\MSSQL\Parameters.

For named instances, the parameters are stored in
HKLM\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL$NamedInstance\MSSQL\Parameters.

I would check all instances on all cluster nodes to make sure they are in
the current proper configuration. Then, run the Cluster Recovery tool to
checkpoint the configuration to make sure the QUORUM contains the proper
registry key information.

Sincerely,


Anthony Thomas


--

<brettestes@xxxxxxxxx> wrote in message
news:1180478382.927737.213590@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi guys,

I had a very odd error occur over the weekend in a development
environment, and I want to see if you've ever heard of this or had
this happen.

Environment:
Active-Active SQL Cluster on Windows 2000 Server, SP4
One instance is called DEV, the other UAT
SQL Server 2000 Enterprise Ed., version 8.0.2040
Both hit an older SAN that has had some I/O issues as of late

Basically, UAT failed over due to some disk issues on the SAN and gave
an error that stated that the ERRORLOG could not be opened because it
was in use by another process. I checked the UAT Startup Parameters
in the registry, and somehow, the -d, -l-, and -e parameters were set
to DEV? Once we took the UAT instance offline and changed the
registry settings, we were able to bring the instance back online.
However, I can't explain how UAT instance grabbed and updated the
registry with the DEV Startup Params.

Has anyone ever had an issue similar to this? How did you explain
it?

Thank you for any information you may provide.

--Brett



.

Relevant Pages

  • Re: Starp up sequence
    ... >> RunServicesOnce ... >> User Profile Startup Folder ... >> the programs specified in the Computer Configuration setting just before ... >> AppInit_DLLs Registry value. ...
    (microsoft.public.windowsxp.customize)
  • Re: Anything like the Windows Registry or INI files for Linux/Unix?
    ... > Linux doesn't have anything like the registry. ... > Linux is not a monolithic something like Windows. ... configuration is in an entirely separate file, ... config files that may provide long term commentary of what ...
    (comp.os.linux.misc)
  • Re: Enabling Add Ons (IE 7)
    ... drill down through Computer Configuration> Administrative ... Templates> Windows Components> Internet Explorer. ... Should you wish to search the registry for that key... ... Do you have more detailed instructions on locating the DWORD ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Storing persistent configuration on separate partition using RegLoadKey
    ... it would be beneficial to move to use an application profile that can be moved around much easier that registry ... is the only EWF protected partition and is about ... >> store persistent configuration information in a file on the D: ... >> the registry since one can only load hives directly under HKLM or HKU ...
    (microsoft.public.windowsxp.embedded)
  • Re: Problem with a persistent policy (real GPO). . .
    ... the Computer configuration to "not configured" for ICS, ... Registry setting, but the ICS still does not work? ... (I am 99% sure the policy setting is Disable ...
    (microsoft.public.windows.group_policy)