• I'm inclined to agree with Ben. It does depend on how you define the terms, but I generally do not think of ldf as a database file.

    It stores log information, and while that can be valuable it does not store relational database information per se. You can destroy and recreate the ldf file with very minimal consequences, but if an mdf or ndf file is damaged you will be looking for the backups.

    ---
    Timothy A Wiseman
    SQL Blog: http://timothyawiseman.wordpress.com/