Tej_7342 (11/5/2013)
The log file fills up if i am using the query. (Database is in Simple Recovery). Any ideas?
Why not consider running the job daily then instead of weekly? I'm assuming that the data are inserted on a daily basis.
Edit: Talking about this query
delete from Table1 where Table1.DateTimeColumn < dateadd(ww, -2, getDate())