• I don't have a problem with the data being read-only (to start with at least).

    As per my previous post, we use snapshots to create "secondary" tables with views off those (where necessary) for people to report against.

    The snapshots are currently taken at midnight to cover the previous day (we don't need/use anything newer than that).

    From what little I know about transaction log shipping, the logs would need to be shipped on a slightly more regular basis than once a day or they would grow out of control.

    At a rough calculation, around 1000 records are actually added to the database(s) a day but there are a lot of updates (I haven't a clue how many to be honest, but I would guess at least 10,000).

    I'm fairly certain the log shipping minimum is every 15 minutes so that might be a good place to start (I'm willing to start elsewhere to start with and alter the times accordingly though).

    As far as I know, the schema won't be changing and there will only be minimal changes to the data.