• Exactly. Earlier when I just stepped in this profession, I though mirroring or log-shipping will take care of the job. But as you know, mirroring is almost identical to prod database, log-shipping is lagging bu usually 30 minutes or 1 hour

    but...but...but

    these solution will not cover some scenarios like Gail and Perry mentioned.

    What if something got deleted or updated by mistake 2 days back and you got to know about it now...

    What if there is corruption due to hardware in the database

    I often got yelled at for asking more servers and hardware for log-shipping, replication and backups but the bottom line is to give best suggestions and then agree to what your boss approves it as per their budget but make sure you give them best recommendations because worrying about budgets is not our headache.(Not till date for me atleast).

    Chandan