General discussion

Locked

Database restore with different characte

By JBA ·
I'm trying to restore a database which was backed up in a different Character Set, Sort Order and Unicode collation and of course I get an error message stating that SQL Server cannot restore the DB.

Can someone tell me how must I setup SQL Server Character Set, Sort Order and Unicode collation during Setup or using the RebuildM utility to have a Unicode locale id of 1033, a Unicode comparison style or 196611 and a sort order of 52? Thanks in advance...

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Database restore with different characte

by msullivan In reply to Database restore with dif ...

You have to install a new SQL server. Be sure to select the Code Page, Character Set, Sort order and Unicode you need.

Your code page is 1252, sort order is "nocase_iso".

Your locale ID is "general unicode"

I'm not sure about the value foryour Unicode comparison style, but I think it may be a default.

Once you have installed the new SQL Server with these parameters, you should be able to restore your database.

Mike Sullivan
MCSE+I, MCDBA, MCT

Collapse -

Database restore with different characte

by JBA In reply to Database restore with dif ...

The question was auto-closed by TechRepublic

Collapse -

Database restore with different characte

by sasha.memedovic In reply to Database restore with dif ...

Shut down all SQL apps/services on the local server
Insert SQL7 CD into drive
Go to C:\MSSQL7\BINN\Rebuildm.exe - double click on it to start "Rebuild Master box"
Click browse and select x86\data directory from the CD
Click "Settings" and pick:196611(character Set)
52(sort order)
1033(local identifier)
All other boxes UNSELECTED
Click OK and then Rebuild
Restart SQL Server on local server

Collapse -

Database restore with different characte

by JBA In reply to Database restore with dif ...

The question was auto-closed by TechRepublic

Collapse -

Database restore with different characte

by JBA In reply to Database restore with dif ...

This question was auto closed due to inactivity

Back to Networks Forum
5 total posts (Page 1 of 1)  

Hardware Forums