INF: Cannot Restore Transaction Log from SQL Server 6.0 to 6.5 (196627)



The information in this article applies to:

  • Microsoft SQL Server 6.5

This article was previously published under Q196627

SUMMARY

Trying to load a transaction log dump from a SQL Server 6.0 server to a SQL Server 6.5 server will fail with the following error message:
Msg 4305, Level 16, State 1
Specified file 'dumpfile' is out of sequence. Current time stamp is
'<date_and_time>' while dump was from '<different_date_and_time>'.

MORE INFORMATION

This is not specifically documented in the SQL Server 6.5 Books Online. When the SQL Server 6.0 database dump is loaded, the upgrade from SQL Server 6.0 to SQL Server 6.5 happens automatically. During the upgrade process, some tables are altered and added. This makes the transaction log invalid.


Modification Type:MinorLast Reviewed:3/2/2005
Keywords:kbinfo KB196627