Article ID: 268081 - View products that this article applies to.
This article was previously published under Q268081
BUG #: 58129 (SQLBUG_70)
If index maintenance operations such as DROP, CREATE, or REBUILD statements occur at the time of a database or transaction log backup, subsequent attempts to load the backup may fail with the following error messages:
The client receives the 1511 error message and the restore processing terminates, which leaves the database in an unrecovered state.
spid8 Could not continue scan with NOLOCK due to data movement.
spid8 Error: 1511, Severity: 21, State: 5
spid8 Sort cannot be reconciled with transaction log.
Starting with Microsoft SQL Server Service Pack 1 (SP1) build 7.00.699, recovery speed was increased by enabling read ahead abilities.
The error condition is triggered when recovery is too aggressive with read ahead operations while rolling forward index maintenance activities.
To work around this problem, enable trace flag 3222. The trace flag disables the read ahead that is used by the recovery operation during roll forward operations.
To enable the trace flag:
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
274799For more information, contact your primary support provider.
(http://support.microsoft.com/kb/274799/ )INF: How to Obtain Service Pack 3 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
The sequence of the errors in the SQL Server errorlog is important. The combination of the 601 error message
and the 1511 error message, without other errors in the error log, is significant.
Could not continue scan.
If the SQL Server server experiences hardware errors, those errors are recorded in the error log as well. In general, the combination of errors shown in this article indicates that the backup file itself is not damaged. All log records exist and are intact.
If you use the trace flag and the backup continues to fail with 1511 errors, please contact Microsoft Product Support Services for further assistance, because this might signify other problems.
Article ID: 268081 - Last Review: March 14, 2006 - Revision: 2.0