SQL Query to delete while database size is larger than 200GB
In a maintenance plan run something like this like hourly 

While((select count(*) from From [dbo].[logs]) &gt; 1000000)
begin
    delete top (10000) From [dbo].[logs] OrderBy DateTime
end