SYMPTOMS
Microsoft SQL Server 2000 supports a new feature that allows users to insert a named transaction in the transaction log and allow recovery to that point, similar to point-in-time recovery as implemented in SQL Server 7.0. In addition, these marks are tracked in the
msdb database, enabling users to determine what marks are available and plan recovery accordingly.
When you use RESTORE DATABASE WITH STOPATMARK or STOPBEFOREMARK to restore to a named transaction, RESTORE remains in loading status if you specify an incorrect named transaction.
This results in the following error message:
This log file contains records logged before the designated mark. The database is being left in load state so you can apply another log file.
Microsoft SQL Server 2005
In SQL Server 2005, you receive the following error message. The database is marked in the
Restoring state in SQL Server Management.Studio.
This log file contains records logged before the designated mark. The database is being left in the Restoring state so you can apply another log file.
WORKAROUND
To get the database out of loading status (without restoring another transaction log backup), run the following statement:
RESTORE DATABASE DatabaseName WITH RECOVERY
where DatabaseName is the name of the database left in load.
REFERENCES
For more information, see the
Recovering to a Named Transaction, and
Backup and Recovery of Related Databases topics in SQL Server 2000 Books Online.