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 |
|
mphelps
Starting Member
12 Posts |
 Posted - 2002-06-05 : 05:18:32
|
| Help needed regarding the following error messagesError: 943 Database 'IF_Catalog' cannot be opened because its version (536) is later than the current server version (515).History of events leading to clients problem1. Upgrade of SQL 7 box to SQL 2000 failed2. Reinstalled SQL 73. Restored master database4. Restored user databases (that had been backed up)5. four Databases that were not backed up left in suspect mode (they forgot to backup certain databases !@#%$#@ )6. Detached database and tried to reattach getting the following error Error: 945 Database 'IL_Catalog' cannot be opened because some of the files could not be activated.7. Set another database into emergency mode with the intention of BCP'ing data out8. Opened database in EM to export data getting the following error Error: 943 Database 'IF_Catalog' cannot be opened because its version (536) is later than the current server version (515).Any assistance in this regard would be appreciated. Otherwise I will be informing the client that their data is LOST FOREVER |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-06-05 : 05:50:18
|
| Your client should have backed up ALL databases before the upgrade.Anyway, the reason for this error is that, those databases got upgraded to SQL Server 2000 and now they can't be opened from SQL Server 7.0.Since you don't have backups, your best bet would be to install SQL Server 2000 as a named instance or on a different server, attach these databases to it. Then use DTS or BCP to copy all the objects and data from these databases to SQL Server 7.0--HTH,Vyashttp://vyaskn.tripod.com |
 |
|
|
mphelps
Starting Member
12 Posts |
Posted - 2002-06-05 : 06:33:43
|
| Hi Vyas,I checked the version that gets created on sql2000 and it is version 539 not 536. Also the version number is stored in master..sysdatabases which was restored from a backup prior to the failed upgrade. Which made me think that it would not be possible. Have successfully attached the database to SQL 2000. Thanks for the assistance |
|
|
|
MuadDBA
628 Posts |
Posted - 2002-06-05 : 12:29:08
|
| I didn't see in your list of tasks anywjere that you installed the same service packs. Could it be a service pack issue? |
|
|
|
|
|
|
Errors attaching Database