|
Home > Archive > microsoft.public.sqlserver.server > October 2002 > database restore error
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
database restore error
|
|
|
| while restoring data back to new sql server error
prompts "The database u r attempting to restore was backed
up under a different unicode locale ID(1033) or unicode
comparison style (196611) than the unicode local ID (1033)
or unicode comparison style (196609) currently running on
this server " Backup or restore operation terminates
abnormally.
| |
| Dejan Sarka 2002-10-05, 9:09 pm |
| Before SQL 2000 you could have collation defined on server-level only, so
you have to have the same collation (code page, sort options) in the
database you are trying to restore. You have to reinstall SQL Server or
rebuild the master database (both quite painful) or use SQL 2000, where you
can have different collations on database and even column level.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Jai" <jaipsharma@yahoo.co.in> wrote in message
news:12d1d01c25d62$9b2a8b30$3a
ef2ecf@TKMSFTNGXA09...
> while restoring data back to new sql server error
> prompts "The database u r attempting to restore was backed
> up under a different unicode locale ID(1033) or unicode
> comparison style (196611) than the unicode local ID (1033)
> or unicode comparison style (196609) currently running on
> this server " Backup or restore operation terminates
> abnormally.
| |
| Wayne Snyder 2002-10-05, 9:09 pm |
| Yes for SQL 7, a database can only be restored on a Server which has the
SAME collation and the server for the original db. So the db can NOT be
restored to THAT SQL Server.
You can either
1. Install another SQL 7 server with the proper collation and restore to
that server OR
2. Install SQL 2000 and restore the database there.
As Dejan stated, SQL 2000 allows EACH database (even down to the column
level) to have a different char set/sort order.
--
Wayne Snyder, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
I support the Professional Association for SQL Server (PASS) and its user
community of SQL Server Professionals.
www.sqlpass.org
|
|
|
|
|