Post reply

sync Databases to secondary server which is used for Read-only

  • September 17, 2014 at 10:12 am

    #296313

    Hiiiiii

    I want to sync Databases to secondary server which is used for Read-only for SSRS purpose,

    these sync can be done once or twice during nightly and mid morning,

    Sync database size would be 400 Gb ,50 GB 60 GB

    What are my options to approach these scenario

    I planned to implement logshipping by using redgate so my backup would be compressed and easier to implement,but i am not sure how to maintain the logfile size for maintenace purpose like when to shrink logfiles because it may grow enoromus untill i take log backup in the night.

    or

    there are any other options like mirroring or replication please advice me on these

    Thank you.

  • September 18, 2014 at 1:59 am

    #1746302

    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

  • September 18, 2014 at 12:40 pm

    #1746520

    Thanks for your reply,so which option is good for reporting services.

  • September 18, 2014 at 3:32 pm

    #1746552

    Personally, I would go with mirroring and database snapshot, but I don't remember if the feature was there in 2005

    -- Gianluca Sartori

  • September 22, 2014 at 10:35 am

    #1747179

    Thanks for your response

Viewing 5 posts - 1 through 4 (of 4 total)

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