«
»

MS SQL 2008 R2 – The counter table was not successfully updated

This is a bit strange to see with an application and is quite simple to resolve. This error here is not related to the application as much as the MS SQL database.

  1. Check the database the application is running against to see if it is in full mode by right clicking on the database and selecting properties and options.
  2. If the database is in full mode ensure the TLOGs are being backed up. Chances are the transaction logs are not being backed up.
  3. Right click on the database and select tasks – backup and select to backup the transaction log.
  4. Once the transaction log is backed up restart the application and you should see the error message disappear.

That is all there is to resolving the issue of the counter table not updating. I would recommend creating a management task to back up the transaction log on a regular basis to avoid future occurrences of this issue.

Enjoy.

This entry was posted on Wednesday, August 7th, 2013 at 8:29 pm and is filed under Windows. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

Comments are closed.