In this presentation, I demonstrate a simple operational data store that is based on log shipping to a secondary SQL instance.
Presentation history:
- SQL Saturday 444 (Kansas City), 10/3/2015
Comment: One attendee indicated on the feedback form that they wouldn’t be able to use the scripts because they had a 300GB database. I neglected to mention during the session that in our environment, we are using this method on a 700GB database. The limiting factor isn’t so much the size of the database (other than the need to have two copies on the secondary system); the limitation is the more the transactional volume and whether the secondary system can keep up with it.