• dbursey (5/5/2013)


    That way, we have our reporting version which is only 24-hours old.

    IF your server storage is on a SAN and the main server and the reporting server are on the same SAN, ask the SAN folks if they could setup an automatic SAN "snapshot" for you. The update time every night would be measured in seconds or less.

    If not on a SAN or the particular SAN doesn't have that capability, then you might want to consider "replication" which will do most everything automatically and could be used to keep the reporting database in sync up to the minute.

    Of course, the backup/restore method DOES test the production backups for viability and that's a major warm-fuzzy.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)