• Well that limits your options to:

    1. backup and restore nightly (not a great option with a 10TB database)

    2. Replication (Transactional)

    3. SAN Replication if applicable

    4. 3rd party tool (like Red Gate Compare Tools) to script out the daily DML (if any) and DDL changes that took place over the day.

    #1 doesn't seem like a good fit

    #2 may have an impact on the performance of your production server

    #3 good option, but you would have to talk to your SAN Admin (assuming you have one)

    #4 Depends on the amount of data that changes daily



    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]