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 - 2002-09-04 : 11:29:55
|
| Draymond Kebile writes "Recently I have had to reinstall SQL 7.0 on the server.Before doing this I backed up the databases locally using the normal SQL backup utility.I then uninstalled SQL from the server,restarted the machine and reinstalled SQL.Everything went smoothly until I had to restore the databases.I could not restore any of the databases.The error message was as follows:"The database you are attempting to restore was backed under a different Unicode locale ID(1033) or Unicode comparison style(196609) than the Unicode locale ID(1033)or Unicode comparison style(196611)currently running on this server."Next I decided to create the databases manually and then restore from a Dlt backup tape medium.This overwrote the newly created database but when I try to access the database through Enterprise Manager I could not because the database was flagged as suspect.How do I sort either if not both of these problems?You help will be appreciated.Thanking You.Draymond KebilePC and Network Support AnalystAfrican Products(Pty)Ltd |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-09-04 : 13:05:34
|
| You haven't installed the new server in the same way as the old.As v7 doesn't support datbase specific collations you can't restore the database.You will have to either re-install or rebuild master with the correct collation.This is probably something like accent sensitive or such.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Restoring databases