October 2, 2001 at 9:05 pm
Today our SQL 6.5 server had a bad crash and we had to scrape the box. I reinstalled
SQL 6.5 and applied SQL Service Pack 5a. To restore the master database I stopped the SQL
service and typed the following command:
D>sqlservr /c /dd:\mssql\data\master.dat /m
The service started but immediately failed:
2001/10/02 14:38:36.01 kernel Microsoft SQL Server 6.50 - 6.50.416 (Intel X86)
Jan 23 1999 14:10:24
Copyright (c) 1988-1997 Microsoft Corporation
2001/10/02 14:38:36.01 kernel Copyright (C) 1988-1994 Microsoft Corporation.
2001/10/02 14:38:36.01 kernel All rights reserved.
2001/10/02 14:38:36.01 kernel Logging SQL Server messages in file 'D:\MSSQL\LOG\ERRORLOG'
2001/10/02 14:38:36.01 server Using Critsecs w/ spincount of 4000
2001/10/02 14:38:36.03 kernel Maximum number of pages in batch io is limited to 8
2001/10/02 14:38:36.03 kernel Maximum number of pages in batch io is limited to 8
2001/10/02 14:38:36.03 kernel initconfig: number of user connections limited to 0
2001/10/02 14:38:36.03 kernel initconfig: number of server processes reduced to 32770
2001/10/02 14:38:36.03 kernel SQL Server is starting at priority class 'normal' with dataserver semaphore = 1 (2 CPUs detected, SMPStat=0).
2001/10/02 14:38:36.03 kernel initblkmem: not enough memory for MEMMAP structures
A quick check after the failure showed the server had at least 192MB of free RAM. Any idea what happened?
TIA,
Bill Salkin
October 3, 2001 at 9:57 am
Can you try starting with minimal config (-m I think) and check your sp_configure settings?
Steve Jones
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply