Trying to get a sense of the optimal setup in our environment.
I have a large SQL05 DB (500+GB) that is log shipped to a read-only system over a WAN. I'm currently running in FULL recovery model, with log dumps every 5 minutes during peak hours and 15 minutes off hours.
It's my understanding that BULK_LOGGED recovery model will allow me to maintain log shipping integrity, at the cost of not being able to do a point-in-time recovery to a time within the period covered by the backup.
Given the frequency of our log dumps, does it make sense to run FULL at all -- since I can restore with the BULK_LOGGED log dumps to a 5-minute recovery window? Or do I misunderstand how this works?