• If you follow all these steps, you should be fine as far as data loss goes.

    In other words, you will have your bases covered and should be protected against data loss.

    I might add one more step to the backup - copy the backup to another server somewhere (thus have two copies). This is an extra precautionary step.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events