|
Home > Archive > MS SQL Server > December 2006 > SQL Server 7 - "Unicode Comparison" won't let me restore
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 |
SQL Server 7 - "Unicode Comparison" won't let me restore
|
|
| Rosman Computing 2006-12-12, 12:12 am |
| I'm trying to recover after a hard disk crash, and was able to recover the
MDF and NDF of a database. When I try to attach it to a SQL 7 sp4 Database, I
get this message:
"Could not attach the database because the character set, sort order, or
Unicode collation for the database differs from this server.
Warning: Unicode comparison flags 196611 in database differs from server
Unicode comparison flags of 196609."
Is there any way I can get this in sync so that my SQL Server will be able
to utilize these files to bring the database back?
Thnx,
Bill R.
Chicago IL
| |
| John Bell 2006-12-12, 5:17 am |
| Hi
I assume you have re-installed SQL Server with a different code page? The
easiest solution would be to un-install and re-install. Failing that you
could install a new instance and transfer the database across using the
Import/Export wizard or BCP.
John
"Rosman Computing" wrote:
> I'm trying to recover after a hard disk crash, and was able to recover the
> MDF and NDF of a database. When I try to attach it to a SQL 7 sp4 Database, I
> get this message:
> "Could not attach the database because the character set, sort order, or
> Unicode collation for the database differs from this server.
> Warning: Unicode comparison flags 196611 in database differs from server
> Unicode comparison flags of 196609."
> Is there any way I can get this in sync so that my SQL Server will be able
> to utilize these files to bring the database back?
> Thnx,
> Bill R.
> Chicago IL
>
| |
| Rosman Computing 2006-12-12, 5:17 am |
| Are you able to tell, based on the error message I received, which Code Page
to reinstall? And which one i presently am using?
Right now I really don't have a database, I don't think, since it is just a
MDF and NDF file and hasn't been attached yet.
thanks,
bill r.
"John Bell" wrote:
[color=darkred]
> Hi
>
> I assume you have re-installed SQL Server with a different code page? The
> easiest solution would be to un-install and re-install. Failing that you
> could install a new instance and transfer the database across using the
> Import/Export wizard or BCP.
>
> John
>
> "Rosman Computing" wrote:
>
| |
| John Bell 2006-12-12, 5:17 am |
| Hi
I don't have an instance of SQL 7 available to me to check this, but if you
go into Enterprise Manager it should be on the properties pages for the
server. I assume that your documentation has not got the code page that was
used? The issue may be that you have different case sensitvity settings.
John
"Rosman Computing" wrote:
[color=darkred]
> Are you able to tell, based on the error message I received, which Code Page
> to reinstall? And which one i presently am using?
> Right now I really don't have a database, I don't think, since it is just a
> MDF and NDF file and hasn't been attached yet.
> thanks,
> bill r.
>
> "John Bell" wrote:
>
|
|
|
|
|