Results 1 to 6 of 6

Thread: URGENT (Restore PB)

  1. #1
    sag Guest

    URGENT (Restore PB)



    When I have tried to restore a Backup Database from Tape, I get
    this message :

    The DataBase your are attemping to restore was backed up under a
    different sort order ID (146) than the one currently running on
    this server (52), and at least one of them is non-binary sort order.

    Someone can Help me

    Thanks in advance

    SAG

  2. #2
    Ray Miao Guest

    URGENT (Restore PB) (reply)

    Find a sql server with sort order id 146 to restore the db then trahsfer the db to target server.


    ------------
    sag at 1/24/2002 12:30:22 PM



    When I have tried to restore a Backup Database from Tape, I get
    this message :

    The DataBase your are attemping to restore was backed up under a
    different sort order ID (146) than the one currently running on
    this server (52), and at least one of them is non-binary sort order.

    Someone can Help me

    Thanks in advance

    SAG

  3. #3
    sag Guest

    URGENT (Restore PB) (reply)



    Is not possible to modify my own SQL Server Sort ID ?
    ------------
    Ray Miao at 1/24/2002 1:15:09 PM

    Find a sql server with sort order id 146 to restore the db then trahsfer the db to target server.


    ------------
    sag at 1/24/2002 12:30:22 PM



    When I have tried to restore a Backup Database from Tape, I get
    this message :

    The DataBase your are attemping to restore was backed up under a
    different sort order ID (146) than the one currently running on
    this server (52), and at least one of them is non-binary sort order.

    Someone can Help me

    Thanks in advance

    SAG

  4. #4
    Jason Guest

    URGENT (Restore PB) (reply)


    The target server's Sort Order is: 52, You have to set the sort order to be 146 before you can restore the DB from the backup which was backed up from a server with Sort order of 146. Or like Ray Mao sai, restore to a server that has sort order id 146 and then transfer the data over to the target server.

    ------------
    sag at 1/29/2002 5:47:55 AM



    Is not possible to modify my own SQL Server Sort ID ?
    ------------
    Ray Miao at 1/24/2002 1:15:09 PM

    Find a sql server with sort order id 146 to restore the db then trahsfer the db to target server.


    ------------
    sag at 1/24/2002 12:30:22 PM



    When I have tried to restore a Backup Database from Tape, I get
    this message :

    The DataBase your are attemping to restore was backed up under a
    different sort order ID (146) than the one currently running on
    this server (52), and at least one of them is non-binary sort order.

    Someone can Help me

    Thanks in advance

    SAG

  5. #5
    sag Guest

    URGENT (Restore PB) (reply)


    But How to modifiy the target server's Sort Order ID.
    Thank you in adavnce
    ------------
    Jason at 1/29/2002 10:08:45 AM


    The target server's Sort Order is: 52, You have to set the sort order to be 146 before you can restore the DB from the backup which was backed up from a server with Sort order of 146. Or like Ray Mao sai, restore to a server that has sort order id 146 and then transfer the data over to the target server.

    ------------
    sag at 1/29/2002 5:47:55 AM



    Is not possible to modify my own SQL Server Sort ID ?
    ------------
    Ray Miao at 1/24/2002 1:15:09 PM

    Find a sql server with sort order id 146 to restore the db then trahsfer the db to target server.


    ------------
    sag at 1/24/2002 12:30:22 PM



    When I have tried to restore a Backup Database from Tape, I get
    this message :

    The DataBase your are attemping to restore was backed up under a
    different sort order ID (146) than the one currently running on
    this server (52), and at least one of them is non-binary sort order.

    Someone can Help me

    Thanks in advance

    SAG

  6. #6
    Guest

    URGENT (Restore PB) (reply)

    reinstall


    ------------
    sag at 1/30/2002 8:28:02 AM


    But How to modifiy the target server's Sort Order ID.
    Thank you in adavnce
    ------------
    Jason at 1/29/2002 10:08:45 AM


    The target server's Sort Order is: 52, You have to set the sort order to be 146 before you can restore the DB from the backup which was backed up from a server with Sort order of 146. Or like Ray Mao sai, restore to a server that has sort order id 146 and then transfer the data over to the target server.

    ------------
    sag at 1/29/2002 5:47:55 AM



    Is not possible to modify my own SQL Server Sort ID ?
    ------------
    Ray Miao at 1/24/2002 1:15:09 PM

    Find a sql server with sort order id 146 to restore the db then trahsfer the db to target server.


    ------------
    sag at 1/24/2002 12:30:22 PM



    When I have tried to restore a Backup Database from Tape, I get
    this message :

    The DataBase your are attemping to restore was backed up under a
    different sort order ID (146) than the one currently running on
    this server (52), and at least one of them is non-binary sort order.

    Someone can Help me

    Thanks in advance

    SAG

Posting Permissions

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