Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005
    Posts
    42

    Red face Unanswered: error while restoring the database

    Sir,

    While restoring i am getting following error:

    Server 'bala', Line 1:
    Backup Server session id is: 5. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
    Server Message: Number 602801, Severity 1
    Server 'bala_BS', Procedure 'bs_read_header', Line 0:
    Backup Server: 6.28.1.1: Dumpfile name 'rak_don053480F778' section number 1 mounted on disk file 'C:\bala_Proj\dontrac\don1'
    Server Message: Number 3120, Severity 16
    Server 'bala', Line 1:
    The database you are attempting to LOAD was DUMPed under a different sort order ID (39) or character set ID (2) than the ones running on this server (SortOrd = 50, CharSet = 2). If the sort orders differ, at least one of them is non-binary.
    -----------------------------
    also can anybody tell me how to change sort order

    My server setting R
    Character set :Code page 850 Character set
    Sort order : Binary ordering (cp850)




    Regard
    bala
    Also

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    The sort order and the charset are modified via the sqlloc utility. This is found in the ASE-12_5/bin directory.

    Michael

  3. #3
    Join Date
    Mar 2006
    Posts
    25

    Unhappy

    u can change the character set or sort order in configuration file

    sp_configure "default character set id",characterid

    sp_configure "default sortorder id",sortorderid


    Quote Originally Posted by bala_m
    Sir,

    While restoring i am getting following error:

    Server 'bala', Line 1:
    Backup Server session id is: 5. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
    Server Message: Number 602801, Severity 1
    Server 'bala_BS', Procedure 'bs_read_header', Line 0:
    Backup Server: 6.28.1.1: Dumpfile name 'rak_don053480F778' section number 1 mounted on disk file 'C:\bala_Proj\dontrac\don1'
    Server Message: Number 3120, Severity 16
    Server 'bala', Line 1:
    The database you are attempting to LOAD was DUMPed under a different sort order ID (39) or character set ID (2) than the ones running on this server (SortOrd = 50, CharSet = 2). If the sort orders differ, at least one of them is non-binary.
    -----------------------------
    also can anybody tell me how to change sort order

    My server setting R
    Character set :Code page 850 Character set
    Sort order : Binary ordering (cp850)




    Regard
    bala
    Also

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •