Article ID: 158684
Article Last Modified on 2/22/2005
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q158684
BUG #: 16103 (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.
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'
If the result of this statement is not 0x11020000, you will likely have the problem described when reloading the master database.
This problem does not occur with sort order bin_cp850. Other combinations have not been verified.
Additional query words: fail cannot load
Keywords: kbbug kbsetup kbpending KB158684