Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Restore to different server
Message
General information
Forum:
Microsoft SQL Server
Category:
Backups
Miscellaneous
Thread ID:
00300364
Message ID:
00301596
Views:
23
Ricardo,

For the life of me I can't remember any solution that I may have posted. To the best of my knowledge there's no way restore a backup to a server that has a different character set and/or sort order.

If you have access to your customer's computer, you can have the SEM generate a script to recreate the database objects. Then you can use BCP to pull the data out.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform