Post reply

issue with log shipping

  • November 18, 2010 at 2:38 pm

    #229433

    During Log Shipping Process in sql server 2008,

    I inserted some data in a table at the primary server instance.

    After then, i disable the log shipping.

    Then i am restore the database at secondary server instance.

    But i can't see the updated data in a table at secondary server side.

    Anybody know how to resolve this issue.

    Please help me...

  • November 18, 2010 at 2:49 pm

    #1252762

    Hi

    Then i am restore the database at secondary server instance.

    Here what you have done.

    whether you have taken new bakup or what if you have taken new bakup surely data will be there in New backup.unless and until you take backup after insertion of new data you will not be able to get whole datas

    Verfy whether you have taken new backup to restore the data or what

    Thanks

    Parthi

    Thanks
    Parthi

  • November 18, 2010 at 2:55 pm

    #1252764

    i have not new backup file.I have only new .trn file.

    So when i am going for restore the database, i am using the old one .bak file

    and the recent i get .trn file.so during restoring i am using the new .trn files only.

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

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