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

ID: Q196627

The information in this article applies to:

Microsoft SQL Server version 6.5

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.

Additional query words: tran err msg

Keywords : SSrvSQL_Admin SSrvTran_SQL
Version : WINNT:6.5
Platform : winnt
Issue type : kbinfo