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 |
|
DBADave
Constraint Violating Yak Guru
366 Posts |
 Posted - 2006-02-22 : 13:11:04
|
| Is all sort order & collation information stored in master? I ask because I want to know what will happen if I install SQL Server using the default settings for sort order & collation and then restore master and the user databases, which all have non-default collations. I assume this will work because I believe all information is stored within master. Will this work?Thanks, Dave |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-22 : 13:49:38
|
| I haven't done a restore with a different sort order and collation since 6.5 or 7.0, but in those versions you couldn't restore to a different sort order and collation. This is why it is recommended to use the default settings.Tara Kizeraka tduggan |
 |
|
|
DBADave
Constraint Violating Yak Guru
366 Posts |
Posted - 2006-02-22 : 13:58:31
|
| For this particular server case sensitivity is required so the default won't work. I made the mistake of assuming the production server used the SQL Server defaults. That's what I get for assuming. I decided to reinstall SQL Server, but I'm still curious if I could have resolved the issue by restoring master, model and msdb using backups taken from the production server with the non-default collation. I believe that would accomplish the same thing as rebuilding master.Thanks, Dave |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-02-22 : 14:10:28
|
| There is a route to changing the collation of MASTER etc. in situ. I did it once and vowed never again! Reinstalling is much easier ...Kristen |
|
|
|
DBADave
Constraint Violating Yak Guru
366 Posts |
Posted - 2006-02-22 : 14:24:28
|
| Thanks Kristen. I do feel better about a reinstallation. It wasn't to time consuming.Dave |
|
|
|
|
|
|
Question about Sort Order & Collation