I have a web app that writes data to several different tables. When I create a data set through the app all the data writes to the relevant tables without any problems. However 1 table completely at random seomtimes loses rows of data. I can see the data used to be there as the row id`s no longer exist however I cannot pinpoint when and why this data is being removed from the table. There are over 335,000 rows in this table and just 79 rows that have magically disappeared!!! Any ideas?
There is only one account that has access to the server with the database which uses windows authentication. And as I havent run any delete statements on this table I cant see another reason for the rows to go missing. Also, no triggers. Thank you though
The transaction isolation level is Read Committed. The table hints that the rows were created as the ID`s for the rows are missing which leads me to believe the data has been committed and then somehow removed.
Is it only one type of action you're completing through the web app? Or is their multiple actions from the web app? In other words, are you able to systematically go through one iteration and confirm the rows are available at the end .
How do you know the rows were ever there in the first place? Are you using IDENTITY for the Row IDs? If so, it is possible to generate an identity value, have the insert fail for some reason and you have an unused identity value. Also while identity normally doesn't skip numbers it doesn't guarantee that it doesn't skip numbers.
================================================= Creating tomorrow's legacy systems today. One crisis at a time.