• Steve Jones - Editor (3/29/2009)


    mohit is correct.

    Expiration is for overwriting backups, like if you had multiple ones in a file. (which is a bad idea)

    I'm not saying you're wrong, in fact I agree, but I'm curious why you said that.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning