Non Logged Transactions

• Raghavender Chavva

  SSCrazy Eights

  Points: 8669

  More actions

  April 15, 2009 at 4:27 am

  #73603

  Hi All,

  In our production server which is of SQL Server 7.0 version, Log backup failed with the Following error:

  [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4213: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot allow BACKUP LOG because file 'XXX' has been subjected to nonlogged updates and cannot be rolled forward. Perform a full database, or differential backups.

  [Microsoft][ODBC SQL Server Driver][SQL Server]Backup or restore operation terminating abnormally.

  When we traced out the non logged commands we found that they are executing UPDATETEXT.

  can you please let me know is there any other alternative command for UPDATETEXT which will not effect the Log backup of the database after it got executed ?

  As of now we have taken the full backup of the database after that Log backups are running smoothly.

  Thanks for your help in Advance.

  Thank You.

  Regards,
  Raghavender Chavva

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  April 15, 2009 at 5:33 am

  #977975

  Wow, you're still using SQL 7.0.

  In SQL 2000 or later UPDATETEXT will be logged if your database is in FULL recovery. But I assume an upgrade is not the solution you're looking for.

  So the only alternative would be using UPDATE instead of UPDATETEXT, but that usually means rewriting the frontend application.

  [font="Verdana"]Markus Bohse[/font]