Hi. I wonder what is the best way to make DB backups.
Let's assume I have backups once per day and also I have DB mirror.
If I accidentally delete production DB, then I also delete mirror DB, so I can't recover from mirror. I can recover from this once per day backup, but it will be outdated.
I wonder if there is a way to have backups so it's possible to recover exactly to the point before DB deletion (so no data loss will occur). Can you point me where should I look?