ID Number: Q61038
1.10 1.11 4.20
OS/2
Summary:
SYMPTOMS
After changing the memory in a machine to 13106, SQL Server no
longer start.
CAUSE
SQL Server doesn't start because it has detected that there isn't
enough memory.
RESOLUTION
With versions 1.11 and later, the inability of the server to start
usually doesn't occur because memory limits have been removed.
However, this may be a very suboptimal situation if SQL Server is
using virtual memory exceeding the system real memory, in which
case excessive swapping will occur.
It is possible to start SQL Server again if the default
configuration parameters are reinstalled. The following procedures
can be used to restore the default configuration values:
- For SQL Server version 4.2 and the version 1.1x case-sensitive
database, use the following command:
bldmastr /r
The /r switch rewrites the configuration block only.
- The following command should be used if a SQL Server 1.1x
noncase-sensitive database is being used:
bldmastr /r /C
The /C switch specifies noncase-sensitive. This MUST be the same
as when the database was first installed, or the indexes on the
system tables will be incorrect (other indexes may be incorrect
also; however, the system indexes are the important ones because
they cannot be rebuilt).
With SQL Server version 4.2, the sort order information is not
overwritten if only the /r switch is being used, and the /C
switch is no longer used.
Additional reference words: 1.10 1.11 4.20 BLDMASTR