Microsoft KB Archive/146116

{|
 * width="100%"|

BUG: Load Master DB Can Fail After Master.Dat is Rebuilt

 * }

Q146116

-

The information in this article applies to:


 * Microsoft SQL Server versions 4.2x, 6.0

-

BUG# NT: 12391 (6.00)

SYMPTOMS
When a database dump of master taken from the master database that was upgraded from version 4.21a to 6.0 (with a size of 23 MB) and subsequently loaded into a master from a rebuilt MASTER.DAT (with a size of 25 MB), SQL Server will fail to start and the following (or similar entries) will be present in the errorlog:

95/12/03 18:47:43.94 kernel  Microsoft SQL Server 6.0 - 6.00.121 (Intel X86) Jun 13 1995 11:32:40 Copyright (c) 1988-1995 Microsoft Corporation

95/12/03 18:47:43.94 kernel  Copyright (C) 1988-1994 Microsoft Corporation. 95/12/03 18:47:43.94 kernel  All rights reserved. 95/12/03 18:47:43.95 kernel  Logging SQL Server messages in file 'D:\SQL\LOG\ERRORLOG' 95/12/03 18:47:43.96 kernel  initconfig: number of user connections limited to 20 95/12/03 18:47:43.96 kernel  SQL Server is starting at priority class 'normal' with dataserver serialization turned on.

95/12/03 18:47:44.04 kernel  initializing virtual device 0, D:\SQL\DATA\MASTER.DAT 95/12/03 18:47:44.05 kernel  Opening Master Database ... 95/12/03 18:47:44.17 spid1   Loading SQL Server's  default sort order and character set 95/12/03 18:47:44.18 spid1   Getpage: bstat=0x1008/0, sstat=0, copy=0 95/12/03 18:47:44.18 spid1     pageno is/should be:    objid is/should be: 95/12/03 18:47:44.19 spid1     0x205(517)              0x3(3) 95/12/03 18:47:44.19 spid1     0x205(517)              0x2d(45) 95/12/03 18:47:44.19 spid1   ... extent objid 0x3, mask 0xff/0, next/prev=0x370/0x298

CAUSE
A MASTER.DAT that is created under version 4.21a with the default size of 15 MB and is subsequently upgraded to version 6.0 will have a final size of 23 MB. A new installation of SQL Server 6.0 will generate a MASTER.DAT with a size of 25 MB. During a situation where the MASTER.DAT must be rebuilt, SQL Setup is used and the resulting file size for MASTER.DAT is 25 MB. It is not possible to create a MASTER.DAT that is less than 25 MB.

WORKAROUND
The only options once the MASTER.DAT is lost are to perform either of the following procedures:

 Use a rebuilt MASTER.DAT. This will mean that the current database device files must be reestablished in the master database by using Disk Reinit and Disk Refit commands. The user login accounts will have to be recreated as well. The other alternative is to create a SQL Server 4.21a MASTER.DAT with the correct size, then upgrade this MASTER.DAT to SQL Server 6.0. Once this is accomplished, follow the steps in the "Administrator's Companion" listed for loading a master database dump.

STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: sql6 dump database master

Keywords : kbusage

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600 kbSQLServ420OS2