transaction log not restoring

  • when i am delete or updating a table in primary server it will not refleted.I put restore time as 1 minute.even though for half hour it will not taking transaction log backup automatically.

    Malleswarareddy
    I.T.Analyst
    MCITP(70-451)

  • Did you shared the tlog backup and restored location?

    Is SQL Services is running on domain account with admin right?

    What error is logged in error log/

    Did you checked the tlog backup , copy & restore job history?

    Did you checked the log_shipping_secondary_databases and dbo.log_shipping_monitor_secondary tables are updated or not?

    Please check and inform us!

    "More Green More Oxygen !! Plant a tree today"

  • U checked the share folder on primary??

  • CHECK THE SHARED FOLDER IN SECONDARY also...IT MIGHT BE THE ERROR WITH THE ALERT..

    Also check the logshipping status by querying the tables monitoring log shipping

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

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