• How up to date does the copy need to be kept? Snapshot replication isn't going anywhere anytime soon as far as I know, and should work in standard.

    ... which, at that point, you might just look into backup/restores to the other server. Sorry, scrap that. Not that it's a bad idea (testing your restores is always good), just probably too much downtime if you aren't looking for 'one day behind' upkeep.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA