Eirikur Eiriksson (10/24/2016)

---

myalliku (10/24/2016)

---

Hi Folks,

I have a question to ask you about Database Recovery modes. I have managed an SQL Server and I take full backups for all databases daily. I do not need to take differencial, log backup, mirrorring or log shipping. If I need to restore backup file to the point time when I take backup, it is ok.

If I change database recovery model as Simple, do I have any risk during database corruption? For example, one of my databases is corrupted. Is SQL Server needs to logs(Full recovery mode) to repair it?

Thank you.

Quick question, is the database in full recovery and you are only doing full backups, no log backups? If that is the case then switching to simple recovery is advisable.

😎

Transaction logs are not used for corruption repair but having the log backups theoretically allows for a restoration of the database up to the point of corruption.