Printable View
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
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
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
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
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
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