URGENT (Restore PB)

[sag]

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

[Ray Miao]

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

[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

[Jason]

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

[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