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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-03-10 : 07:22:45
|
| Azlan writes "My server hard disk failed today. After some effort, I managed to recover the contents of the failed disk and copied the database and log file to a new server. After installing SQL 7, I encountered a problem attaching the database. I encountered a host of error messages highlighting incompatible/mismatch "unicode language", "unicode locale", etc. I tried using the enterprise manager to restore the database from the .BAK file and the same messages appear. I think the collation and sort settings I used when installing SQL server is incompatible with the database that I am trying to recover. Does anyone know how to overcome this problem!" |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2003-03-10 : 08:14:10
|
| You need to install SQL Server 7 with the same sort order as before.In order to change it after installation there is a utility called "rebuildm.exe" that you may need to use.Be very carefully using rebuildm.exe!From BOL:Use the Rebuild Master utility to repair a corrupted master database or change the collation settings for an instance of Microsoft® SQL Server™. Before running the Rebuild Master utility, make sure you have the scripts to rebuild the database objects and a backup to reload the data. Rebuilding the master database removes all database objects and data. After rebuilding the master database, re-create the database objects and reload the data. HTH |
 |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-03-10 : 08:59:08
|
| Use RESTORE HEADERONLY option to list out the backed up database sort order, unicodelocaleid and other database information. This will help you in comparing/using rebuildm utiliy.Refer BOL on RESTORE HEADERONLY for more details.___________________________________________________________________________Success is not a destination that you ever reach. Success is the quality of your journey. |
|
|
|
|
|
|
Trying to attach database from recovered disk