Home Forums SQL Server 2005 Administering sync Databases to secondary server which is used for Read-only RE: sync Databases to secondary server which is used for Read-only

  • If you want to keep your log size small, take backups more frequently and ship the logs right away.

    If you need to keep an older copy of your database, you can restore the logs to the secondary setting a higher delay for the restore job.

    Mirroring doesn't let you set a delay between principal and mirror: the changes are always pushed immediately.

    With replication you can change the schedules of the replication agent. Be aware that the distribution database may grow large meanwhile.

    -- Gianluca Sartori