Q

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

This was first published in February 2004

Dig deeper on Microsoft SQL Server Installation

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

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:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close