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
Member
134 Points
286 Posts
SQL Database table values are auto deleted on a specific time
Oct 12, 2018 06:25 AM|shsu|LINK
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
All-Star
43510 Points
15172 Posts
Re: SQL Database table values are auto deleted on a specific time
Oct 12, 2018 08:07 AM|PatriceSc|LINK
Hi,
You mean a column is now blank or rows are deleted ? Could it be a SQL injection Attack ?
Member
10 Points
2 Posts
Re: SQL Database table values are auto deleted on a specific time
Oct 12, 2018 05:02 PM|AKFit|LINK
Are there any sql server batch jobs running on the backend. Was any job modified recently?
Member
134 Points
286 Posts
Re: SQL Database table values are auto deleted on a specific time
Oct 17, 2018 01:27 AM|shsu|LINK
Actually the reason was in the Delete query.