October 8, 2014 at 1:43 am
Hello everyone,
I need some help. I want to daily backup my db in its actual state without any chance to recover old data. I have few daily transactions (therefore I can cope with the loss of last 24h operations in case of crash) and my priority is to be sure that personal data of my clients can't be restored in any way after having been deleted.
The db is in 'simple' recovery mode and I'm taking full daily backups. I see that I'm able to restore db at any point in the past (that I don't want). Maybe I should backup transactions log, backup the db and finally delete the log backup file?
I'm making experiments, but I'd really appreciate your help.
October 8, 2014 at 1:48 am
...
October 8, 2014 at 2:09 am
cris651 (10/8/2014)
The db is in 'simple' recovery mode and I'm taking full daily backups. I see that I'm able to restore db at any point in the past (that I don't want).
No, you won't be able to restore to any point in the past.
In simple recovery, with just full backups, you can restore to the time the backup was taken, that's it. No other recovery options are present in simple recovery. You can't back up the log in simple recovery, so you can't do point in time restores.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 8, 2014 at 2:40 am
Thank you! I tried and you're right: working on a copy of my db, I didn't realize :blush: that in some moment I switched the recovery mode to 'full' and never came back to 'simple'. I switched to 'simple' and the result is exactly what I wanted.
'Simple'! 😀
Thank you again,
Cris
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply