Conference amcucs::ms-sqlsvr

348.0. "sql and dbcheck" by DEKVC::JUNMOKSONG () Fri Mar 14 1997 00:31

     
    
    Hi,
    
    My customer is using two machine as following:
    
    ALPHA machine (64 risc chip)   : MS SQL V6.0 and WNT V4.0
    Avion machine (intel chip)     : MS SQL V6.5 and WNT V4.0
        
    First of all, the DB was in ALPHA and they transfer DB from ALPHA to Avion 
    by SQL SERVER transfer manager. After that, on Avion the performance
    was very slow and almost DB became to stop and  again they transfer DB from
    Avion to ALPHA and check DB by dbcc checkdb, 

    and then the following error was happened.
    
    "Table corrupt keys in data page should be in asending order"
    
     I sow when error is index of page corrupt, it can be drop but
     when error was data of page coppurt, ther is no comment.
    
     So My question is two as following:
    
     1. Can I transfer DB by transfer manager between different
        architecture machine (alpha and intel)?
    
     2. if possible, How can I fix above error?
    
    Best Regards,
    Jun-Mok Song  
     
                                      

    
    You can use Transfer Manager to move a database between Alpha and 
    Intel. 
    
    And you should be able to move from a 6.0 db to a 6.5.  
    
    Have you run a dbcc checkdb or checkalloc on the original database?