Conference amcucs::ms-sqlsvr

378.0. "HELP - Restore Problems" by LACS01::ORLOWSKI () Wed May 21 1997 11:36

    
    I am running SQL Server 6.5 (with SQL Server - service pack 2) on an
    Alpha with NT 3.51. Replication is also running on this server.  
    
    While increasing the tempdb in Ram,  yesterday, I managed to get the
    memory allocation too high (????) and corrupted the Master DB (I
    think). I tried to restore the Master (and msdb) databases from the
    night before's full backup.  
    
    
    All seems to go according to the restore procedures in the SQL Server
    admin manual for the Master db -- BUT once the Master database has been
    restored,  the server (SQL) will not start so I can restore the msdb. 
    When trying to start,  I get the log file that is attached to the
    bottom of the message.  The error message I get when I try to start it
    is to the effect: DB-Library: SQL server is not found or not available
                                                           
    I was able to recreate the same errors (tempdb too large), restore
    Master and msdb on my intel server (pentium) development machine (same
    basic configuration without replication).  BUT, if I follow the same
    procedures on the Alpha, it fails (see log below).
    
    Microsoft knowledge base has been unavailable today, but I could find
    little about it yesterday.
    
    Any ideas???????????????
    
    Regards,
    Stan                                         
    
    
    
    
    
97/05/21 10:54:19.16 kernel   Microsoft SQL Server  6.50 - 6.50.240 (ALPHA) 

	Dec 17 1996 16:18:43 

	Copyright (c) 1988-1996 Microsoft Corporation


97/05/21 10:54:19.16 kernel   Copyright (C) 1988-1994 Microsoft Corporation.
97/05/21 10:54:19.16 kernel   All rights reserved.
97/05/21 10:54:19.16 kernel   Logging SQL Server messages in file 'I:\SQL60\LOG\ERRORLOG'
97/05/21 10:54:19.17 kernel   initconfig: number of user connections limited to 15
97/05/21 10:54:19.17 kernel   SQL Server is starting at priority class 'normal' with dataserver semaphore = 1 (1 CPU detected, SMPStat=1).
97/05/21 10:54:19.17 server   LogLRU buffers: 0

97/05/21 10:54:19.19 kernel   Attempting to initialize Distributed Transaction Coordinator
97/05/21 10:54:19.21 server   Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE

97/05/21 10:54:19.22 kernel   initializing virtual device 0, I:\SQL60\DATA\MASTER.DAT
97/05/21 10:54:19.23 kernel   Opening Master Database ...
97/05/21 10:54:19.31 spid1    Loading SQL Server's  default sort order and character set
97/05/21 10:54:19.32 spid1    Getpage: bstat=0x1008/0, sstat=0x80000000, disk

97/05/21 10:54:19.32 spid1      pageno is/should be:	objid is/should be:

97/05/21 10:54:19.32 spid1      0x211(529)		0x1(1)

97/05/21 10:54:19.32 spid1      0x211(529)		0x2d(45)

97/05/21 10:54:19.33 spid1    ... extent objid 0x1, mask 0xff/0, next/prev=0x210/0x210