recovery model question
-
I have a server with several oltp dbs that are not mission-critical. SLA is to restore to previous day (so a full backup performed each night for each db, no transaction log backups). My question is: is there any value to having recovery model set at Full (instead of Simple) ? Thinking in terms of if user mistakenly deletes data, doing special backup of log and point in time restore. Any other benefits to keeping set at Full vs Simple if not planning on regular trx log backups? I guess I am not comfortable with having log truncation on checkpoint on a production system. Any ideas appreciated.
-
I'm with you. Having the model as Full allows you to make a tran log backup when disaster strikes and be a hero by recovering more than just the previous night. If you keep the last few tran log backups, it also allows you to recover forward independently from a potentially corrupt or missing full backup. Just backup the tran log before doing your full backup and save as many tran log backups as you do full backups. That shouldn't add much complexity to your processes, but it will let you sleep easier.
If you're serious about not regularly backing up the tran logs, you could just truncate the log before your full backup, but that's not much easier than backing it up, is it?
--Jonathan
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply