February 19, 2003 at 2:43 am
Hello :
I can't find information about my question in the forums but I think that my problem is a problem that someone have happened.
I am trying to restore a backup db from one server to another and I receive one error. The original server have LOCAL UNICODE 3082 and the destination server have LOCAL UNICODE 1033. ¿Is it possible to change the UNICODE 1033 in the destination server? ¿Which are the best way to do it? . I would like not to reinstall sqlserver 7.0 if it is posibble. If this was the only solution, ¿which are the best way to maintain the actual data? ¿Backup/restore, Export/Import, detach/atach?. If the best solution are Export/import or Detach/Atach, ¿would you mind to explain to me the way to do it?.
THANKS IN ADVANCE. Sorry about my English
Jesús
February 19, 2003 at 7:59 am
If you have SQL Server 7 and have different sort order,local unicode,unicode collation or different character set, you will need to rebuild master database with rebuildm.exe utility.
From BOL:
Before you run the Rebuild master utility, make sure you have one of these two items:
The scripts to rebuild the database objects and a backup to reload the data.
The data and log files to use with sp_attach_db.
Rebuilding the master database removes all database objects and data. After rebuilding the master database, re-create the database objects and reload the data, or reattach the data and log files using sp_attach_db.
HTH
Franco
Franco
Edited by - franco on 02/19/2003 08:00:06 AM
Edited by - franco on 02/19/2003 08:00:43 AM
Franco
February 20, 2003 at 1:04 am
Thanks a lot Franco.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply