Error when trying to restore a database 
Author Message
 Error when trying to restore a database

Hi,

Our ISP is hosting a SQL Server 7 SP2 cluster for us however whenever I try
to restore backups from our server to theirs I get the following error
message:

The database you are attempting to restore was backed up under a
different Unicode locale ID (1033) or Unicode comparison style
(196611) then the Unicode locale ID (1033) or Unicode comparison
style (196609) currently running on this server.
Backup or restore operation terminating abnormally.

I have my suspicions that this is a problem with the default language of the
machine when the server was installed ours was English - British and theirs
was English - United States (Both servers are in/for England) but our ISP
swears blind this is not the case and we have a problem with our servers.

Can anyone confirm the cause of this and the required solution because our
ISP is getting stubborn at the prospect of potentially changing the cluster
configuration.

Thanks,
Ross.



Sat, 22 Feb 2003 18:39:24 GMT
 Error when trying to restore a database

Thanks Tibor,

I can go to my ISP with a suitable solution to the problem now.

Ross.

Quote:
> Ross,

> when you install SQL Server, you select Sort Order, Character Set and
Unicode
> Collation (you much chose custom). If you load a backup, this must match.
> So, you have to install some other SQL Server to load this backup. Or
rebuild you
> installation (rebuildm.exe), but you'll loose all data.
> Search in Books Online for the numeric representation to get an idea about
what to
> chose in the install/rebuild dialogs.

> --
> Tibor Karaszi, SQL Server MVP
> Please reply to the newsgroup only, not by email.



> > Hi,

> > Our ISP is hosting a SQL Server 7 SP2 cluster for us however whenever I
try
> > to restore backups from our server to theirs I get the following error
> > message:

> > The database you are attempting to restore was backed up under a
> > different Unicode locale ID (1033) or Unicode comparison style
> > (196611) then the Unicode locale ID (1033) or Unicode comparison
> > style (196609) currently running on this server.
> > Backup or restore operation terminating abnormally.

> > I have my suspicions that this is a problem with the default language of
the
> > machine when the server was installed ours was English - British and
theirs
> > was English - United States (Both servers are in/for England) but our
ISP
> > swears blind this is not the case and we have a problem with our
servers.

> > Can anyone confirm the cause of this and the required solution because
our
> > ISP is getting stubborn at the prospect of potentially changing the
cluster
> > configuration.

> > Thanks,
> > Ross.



Sat, 22 Feb 2003 20:02:37 GMT
 Error when trying to restore a database
 I have similar problem but I installed 2 SQL Servers with *.iss file. It
means that my servers have the same Sort Order, Character Set and Unicode. I
am able to move database (backup and restore) DB1 from server A to server B.
When I try to move database BD2 from server A to server B, I get error
message :
 " The database you are attempting to restore was backed up under a
different sort order ID (83) than the one currently running on this server
(81), and at least one of them is a non/binary sort order. "

 I tried to check data integrity on DB2 with the "DBCC CHECKDB (DB2)"
statement and data integrity is OK.

 Any suggestion?

 Thanks

Zdenek


Quote:
> Ross,

> when you install SQL Server, you select Sort Order, Character Set and
Unicode
> Collation (you much chose custom). If you load a backup, this must match.
> So, you have to install some other SQL Server to load this backup. Or
rebuild you
> installation (rebuildm.exe), but you'll loose all data.
> Search in Books Online for the numeric representation to get an idea about
what to
> chose in the install/rebuild dialogs.

> --
> Tibor Karaszi, SQL Server MVP
> Please reply to the newsgroup only, not by email.



> > Hi,

> > Our ISP is hosting a SQL Server 7 SP2 cluster for us however whenever I
try
> > to restore backups from our server to theirs I get the following error
> > message:

> > The database you are attempting to restore was backed up under a
> > different Unicode locale ID (1033) or Unicode comparison style
> > (196611) then the Unicode locale ID (1033) or Unicode comparison
> > style (196609) currently running on this server.
> > Backup or restore operation terminating abnormally.

> > I have my suspicions that this is a problem with the default language of
the
> > machine when the server was installed ours was English - British and
theirs
> > was English - United States (Both servers are in/for England) but our
ISP
> > swears blind this is not the case and we have a problem with our
servers.

> > Can anyone confirm the cause of this and the required solution because
our
> > ISP is getting stubborn at the prospect of potentially changing the
cluster
> > configuration.

> > Thanks,
> > Ross.



Tue, 25 Feb 2003 15:54:54 GMT
 Error when trying to restore a database

Quote:
> I have similar problem but I installed 2 SQL Servers with *.iss file. It
> means that my servers have the same Sort Order, Character Set and Unicode.

According to the error message, they don't. Run sp_helpsort on the two installations
and see if you get the same.

--
Tibor Karaszi, SQL Server MVP
Please reply to the newsgroup only, not by email.
See Neil Pike's FAQ at: http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800

Quote:

> I have similar problem but I installed 2 SQL Servers with *.iss file. It
> means that my servers have the same Sort Order, Character Set and Unicode. I
> am able to move database (backup and restore) DB1 from server A to server B.
> When I try to move database BD2 from server A to server B, I get error
> message :
>  " The database you are attempting to restore was backed up under a
> different sort order ID (83) than the one currently running on this server
> (81), and at least one of them is a non/binary sort order. "

>  I tried to check data integrity on DB2 with the "DBCC CHECKDB (DB2)"
> statement and data integrity is OK.

>  Any suggestion?

>  Thanks

> Zdenek



Tue, 25 Feb 2003 18:35:30 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Error whilst trying to restore a database

2. Error when trying to restore my database using RMAN

3. Error 603 when trying to restore a SQL 6.5 database

4. error 14274 (trying to edit job after restoring msdb)

5. Sector Size Error When Trying To Restore

6. SQL-DMO Error while trying to restore

7. Error 927 when trying to restore from dump :-(

8. Error 10005 when trying to restore DB (urgent please)

9. Restore from Historical Replication - Still receiving errors after trying you r suggestions

10. Trying to restore master database

11. HELP. Trying to restore database

12. Desperately trying to restore database!


 
Powered by phpBB® Forum Software