Create a Simple Operational Data Store

In this presentation, I demonstrate a simple operational data store that is based on log shipping to a secondary SQL instance.

Presentation history:

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.