October 24, 2016 at 12:25 am
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.
October 24, 2016 at 3:33 am
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.
October 25, 2016 at 7:44 am
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.
Thank you for your quick response.
You are right. I asked that you say 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply