Microsoft KB Archive/37629

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 19:21, 12 August 2020 by X010 (talk | contribs) (X010 moved page Microsoft KB Archive/Q37629 to Microsoft KB Archive/37629 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

PRB: Resetting Configuration Parameters to Defaults ID Number: Q37629

1.00 1.11 4.20 OS/2


SYMPTOMS The memory parameter of SQL Server was inadvertently set too high and cannot be reset because the SQL server will not come up.

RESOLUTION One method to reset the SQL Server configuration parameters is to reload the master database; however, the BLDMASTR utility -r option will reset the configuration parameters to the defaults without affecting the master database or user databases. The -d parameter must be used to specify the name of the MASTER.DAT file. If MASTER.DAT was originally case-insensitive, the -C option must also be specified.

Additional reference words: bldmastr case insensitive case-insensitive