SQL Server Database going into suspect mode after bulk insert and delete I'm working on an application that does a bulk copy of data from one table to another within the same database (using an Insert... Select) and then deleting the data from the source table. In production, sometimes the database goes into suspect mode and I have noticed that it always happens after this process is run. This process does this to multiple tables (around 20 tables). First it copies the relevant data from each table to its corresponding archive table. Then it deletes the relevant data from the source tables.  

I checked on common reasons for this and there is enough free space in the disk and no antivirus software installed

Edit: Auto Close is disabled for the database
I'm quite sure that the transaction log might be broken. Did you check the serverlogs? Another idea could be that to set the emergency mode in your database and run a dbcc checkdb and take a look at the results.

I can't find a good reason for this behaviour. Maybe a bit code would help. I don't have any of this issues, even as I'm using such operations quite often. 

Maybe another idea is this way:


Call procedure
Copy tables
Run Checkpoint
Clean tables on source