Problem solve Get help with specific problems with your technologies, process and projects.

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?

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

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.