Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
moisesfernando
Starting Member
11 Posts |
 Posted - 2004-05-21 : 15:24:14
|
| Hello,I was trying to make a restore from a database backup. When the restore starts, SQL displays a error, showing that "Unicode comparison style" is different, between the actual database and the file that was retored from backup. I saw SQL Books Online and there was a command, using sp_configure to make the "Unicode comparison style" same. USE masterEXEC sp_configure 'Unicode comparison style', '196609'RECONFIGURE WITH OVERRIDEAfter run this command, 'Unicode comparison style' was the same that the another server where the backup was from. After that, I stop the SQL service and don't restart this services anymore.I reboot the server, try to start manually, etc. What can happen ?Thanks,Moises |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-21 : 15:36:29
|
| DOH!!!! You ran this on the master database??? Do you have a backup of master?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
moisesfernando
Starting Member
11 Posts |
Posted - 2004-05-21 : 15:38:58
|
| Yes, the command was executed on the master database. No this server is for test only, we don't have backup for this server. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-21 : 15:41:59
|
| Look up rebuild master in Books Online. You can run that and you'll be fine (I think). I've never exactly done this before for this reason. :)MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
|
|
SQL Doesn't Start Services