Ask the Expert

Getting error when dropping, inserting into or truncating table with QA

We use SQL Server 2000 with the latest service pack. Whenever I drop, insert into or truncate a table via Query Analyser, I get an error reported by the hourly backup job running on the server. The error is:
 Cannot allow BACKUP LOG because file 'BDAS_Data' has been subjected to nonlogged updates and cannot be rolled forward. Perform a full database, or differential database, backup. [SQLSTATE 42000] (Error 4213) Backup or restore operation terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
How can I fix this error?

    Requires Free Membership to View

It may sound like a silly question but I'll ask it anyway? Are you sure that you are using SQL Server 2000? If so, this should not be happening and you may have a corruption problem of some sort. Everything in SQL Server 2000 is logged in one way or another and should not break the transaction log backup sequence. See this url for more information: http://support.microsoft.com/default.aspx?scid=kb;en-us;272093

 

For More Information

This was first published in February 2004

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: