LS

  • i added one secondary database file on the primarydatabase where the db is configured in logshipping on E drive , how can i restore the file to the secondary server where E drive is not present ? what happens my logshipping

  • 1. Locate the first LOG backup that has been made on the primary after the database file was added.

    2. Restore all LOG backups on the secondary prior to the LOG backup of the previous step.

    3. Manually restore the LOG backup from the first step on the secondary and use the WITH MOVE option to place the added file to an existing location

    After the above steps the logshipping would continue to work properly.

    If the above fails you could also create a differential backup on the primary. Restore this on the secondary using the WITH MOVE option. Remove or move all LOG backups prior to the differential to speed up the logshipping.

    Bottom line: you need to restore a back-up on the secondary using the WITH MOVE option to place the added files to an existing location.

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

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

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