• Some more background.

    I am hosting an application out of datacenter out east and if it goes down, we'll merely redirect things so app hits the datacenter out west.

    The nature of our data is fairly static. It is hardly transactional.

    Data is loaded a couple times a day from raw source files. Copies of those source files are sent to the out west data center and also imported there to keep the gigantic fact databases sync'd up. Call that the "log" ship. 🙂

    Where I need help are a couple other databases I use for system control stuff (like a logging database) need to stay up to date, too. They are simple, and aren't populated from raw source files. Perhaps the best solution is to change these couple others to Full and manage things with log shipping.

    What are your thoughts?