• Apart from the other stuff that has been said i would also suggest that from what i have seen the number one cause of the log file becoming big is that someone has left SQL on default settings and they dont know what there doing.

    So they should either

    A) Put it in simple - if that is what is required by the business\system. 99 times out of 100 i have seen systems that they want backed up nightly, and that is sufficient loss - but the database is in full mode.

    B) If on the rare occasion they do want more then nightly (sometimes you get "oh can you do that") then they need to be backing up the logs and maybe doing diffs. This is rare as people who normally want this backup regime know enough to actually know they need to implement it.

    Most times its a pop it in simple and the LSN`s are irrelevent to the backup regime they have.

    Dan