• there are many ways to handle this..

    1. take regular log backups.

    2. log shipping.

    3. mirroring

    hope this helps.



    Praveen D'sa
    MCITP - Database Administrator 2008
    http://sqlerrors.wordpress.com