BUG: Unable to Reload Master DB After Upgrading SQL Server

• Microsoft SQL Server, version and 6.5

SYMPTOMS

In certain environments, a dump of the master database created after an upgrade from SQL Server version 6.0 to SQL Server 6.5 cannot be used to re-create the master database after a system failure. In such a case, rebuilding the master device and loading the latest master dump will shut down the server as expected, however, a subsequent restart of the server will fail. At the end of the errorlog, you will find the following message:

   Getpage: bstat=0x1008/0, sstat=0x80000000, disk
      pageno is/should be: objid is/should be:
      0x211(529)      0x1(1)
      0x211(529)      0x2d(45)
   ... extent objid 0x1, mask 0xff/0, next/prev=0x210/0x210

STATUS

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

MORE INFORMATION

This problem occurs if SQL Server was installed with the default values for the sort order and code page (nocase/iso_1). To check this, run the following statements in the master database:

   select substring(textptr(definition),1,4)
   from syscharsets where name = 'nocase'

This problem does not occur with sort order bin_cp850. Other combinations have not been verified.