I have a 100 million record table(60GIG). The database is in simple recovery mode for various reasons. I want to start archiving this table witch would involve mass inserts into another table and mass deletes from the main table. It is my understanding since I am in simple mode that this will not affect my transaction logs at all. Is that correct? Is there any other reason I should fear?
By the way I have many other databases on the same instance of SQL server and all the others are in full recovery mode.