locked
SQL Database table values are auto deleted on a specific time RRS feed

  • Question

  • User-1578974752 posted

    At 11:30 PM all the values of a certain sql database table is deleted. User can not any way delete one by one.

    Two days happened as above .Not sure why .Any recycling happening at that time..If so why happening to only one table while all other values are still there.

     What could be the reason? Any suggestions? Appreciate your help

    Friday, October 12, 2018 6:25 AM

All replies

  • User753101303 posted

    Hi,

    You mean a column is now blank or rows are deleted ? Could it be a SQL injection Attack ?

    Friday, October 12, 2018 8:07 AM
  • User998287339 posted

    Are there any sql server batch jobs running on the backend. Was any job modified recently?

    Friday, October 12, 2018 5:02 PM
  • User-1578974752 posted

    Actually the reason was in the Delete query.

    Wednesday, October 17, 2018 1:27 AM