Post reply

Another doubt in the testing case i got

  • June 28, 2013 at 3:31 am

    #295207

    In primary server

    1.taken full backup daily

    2.taken differential backup

    3.taken transactional log backup

    4.logshipping is running and transactional log backups are genrating at every 10 mins

    in secondary server how can we restore transactional log manually without the data loss

    Thanks
    Naga.Rohitkumar

  • June 28, 2013 at 3:42 am

    #1628236

    Restore the last full and differential backup from primary on secundary and leave the database in NORECOVERY or STANDBY. Restore each log backup on secundary after this is created on the primary, still leaving the database in NORECOVERY or STANDBY. In case of disaster create a TAIL LOG backup on primary and restore this on the secundary. Set the database on secundary to RECOVERY if the secundary needs to serve the application because the primary is crashed.

    The restore of the LOG backups can be setup as an automated process. This is preferred above a manual approach.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • June 28, 2013 at 4:17 am

    #1628243

    Looks like the original poster has made a double post, see http://www.sqlservercentral.com/Forums/Topic1468474-384-1.aspx

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • June 28, 2013 at 4:26 am

    #1628244

    This is different post iTs for Testing in T& server to get correct idea

    Thanks
    Naga.Rohitkumar

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

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