• If the log is on the same drive, don't purge any data until you've given the log more space!

    If the log is out of space, and particularly if it getting errors about it, you must add log space first. If necessary, you can temporarily add another log file on a different drive. First you must get the log file in working shape, then and only then can you safely purge data.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.