If I bring SQL offline, dont I need to bring it online to detach the DBs? In that case, I establish new connections before I can run the detach script.

Yes, its a log table for audit. But we only need last 7 days. Since we never deleted data from this table, we ended up with so many records. We...

Sweet, will try the approach of moving data to another table and renaming. Thanks!