What will be the best way to send the production data to a separate server on daily basis?

  • I recently implemented a solution to this problem, and used (quite reliably) a combination of Jobs on the SQL Servers and DOS-based batch files (with Xcopy commands).

    We took it one step beyond the "once-a-day" thing, though -- we are creating hourly transaction logs, xcopying them over to the backup db server, then restoring them. So, we have a backup db server that is synchronized with the production server within one hour (without the overhead and complexities of replication or snapshots or the like)

    I'd be more than happy to share those files with anyone who wants to see them.

    Thanks,
    - Joseph Marsh

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply