Knowledge Base

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

Article ID: 196627

Article Last Modified on 3/2/2005

APPLIES TO

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.


Additional query words: tran err msg

Keywords: kbinfo KB196627


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.