Log shipping

  • hello experts,

    i have configured log shipping in stand by mode and thn i inserted some rows on primary database bt m not getting any changes on secondry wanto to knw why is this so???

    bt one of my frnd telling he is able to access changes in stand by mode

    pls help

  • Hi,

    How did you set up the log shipping , manually or wizard. Was the log applied on the secondary? what frequency is configured for the log to ship.

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

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

  • i configured through the wizard, and i m doing for practice purpose, so frequency of job is

    backup in every 15 seconds

    copy in every 20 seconds

    restore in every 25 seconds

    let me knw if any othr frequency can be set?

    want to knw in stand by mode logs are restored? means changes are transferred to secondry

  • You can check the restorehistory in msdb database to conform the restore. View logs for the jobs

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

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

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

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