No, you'll have to switch to Simple Recovery. If you're deleting all the rows in a table, you could use TRUNCATE TABLE, that command is logged minimally logged in SQL Server.
Roman
>Dear sirs:
>
>I have to delete at least 1 and a half million rows of one table in my data base, the problem is that my log file grows to much in the process. Is there a way to stop the log while the delete is going on?
>
>Thank you in advance
Roman Rehak, MCSD, MCDBA, MCSA
Competitive Computing
354 Mountain View Drive
Colchester, VT 05446-5824
802-764-1729