• Hi,

    If your recovery model is full and you don't take a log backup then your log file will fill the drive it is sat on. If you don't care about point in time recovery use the simple recovery model.

    Thanks,

    Simon



    MCSE: Data Platform
    MCSE: Business Intelligence
    Follow me on Twitter: @WazzTheBadger
    LinkedIn Profile: Simon Osborne