Microsoft KB Archive/37629

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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