Perry Whittle (2/12/2016)
Sorry, I'm confused, you sayPiMané (2/11/2016)
The recovery mode should be FULL, since the primary data is very, very important..Then you say
PiMané (2/11/2016)
I forgot to mention I don't need to restore to a point in time...I just need to restore if the database crashes or something else goes wrong.
Why set Full recovery in the first place
If recovery mode is not FULL and the database has problems I'll only have the last full backup (that can be an hour earlier) and without the logs backups I can't rebuild to the point when it crashed! Or can I?!
And the tail log backup won't exist since the log is "disabled"...