restore backup from SQL 7 to SQL 2000

[douggy]

I am trying to restore a Full SQL 7.0 DB backup and subsequent transaction log backups. I am restoring this backup to SQL 2000 database.

The full backup restores fine, however on restoring the third TRN backup I can the following error:

=======================================
Micrsoft SQL-DMO (ODBC SQLState: 42000)

This version cannot redo any index creation or non-logged operation done by SQL Server 7.0. Further roll forward is not possible. RESTORE LOG has been halted. To use database in its current state, run RESTORE DATABASE TestRestore WITH RECOVERY. RESTORE LOG is terminating abnormally.
=======================================

Could anybody shed any light on this?

Regards
Mark

 

[JayKusch]

Pretty straight forward. In your SQL Server 7 you either ...

a. Created an index on a table
OR
b. Performed a non-logged operation. Maybe a Truncate
table or some other similar operation.

Either on of those events was entered in the SQL Server transaction log.

Now SQL Server 2000, which you are trying to restore to is saying it cannot apply the current TLog backup because of one or both of the events listed above.

It is saying you can forego applying the current TLog backup, as well as any other TLog backups you may have, and restore the DB AS IS!

The current DB WILL NOT fully reflect the SQL Server 7 DB you were trying to restore.

A workaround, if possible, is to restore the backups to a SQL Server 7 installation. Then you should not run into the issue at hand. Once it is full restored, make a full backup and then restore that to your SQL Server 2000 installation.





Thanks

J. Kusch