Logshipping to another server with different drive names

  • Hello,

    We have primary with drive F,L and secondary server with drives D,L.

    Data files from F goes to D in secondary and Log file from L goes to L in secondary.

    every thing goes smooth untill a new data file is added primary server which will be on F drive , how to get the DB sync happen with the new file created in D drive of secondary server.

    Is there a possibility to sync it automatically?

    Regards
    Durai Nagarajan

  • this is a common problem that is encountered with log shipping and mirroring when the servers are using disparate drives\paths.

    Best way is to

    • disable the LSbackup job
    • run the LSCopy and then the LS restore jobs to ensure all remaining logs have been applied
    • create the new file on primary
    • take a manual differential backup on the primary
    • restore the differential to the secondary with NORECOVERY and the MOVE option specifying the correct drive\path for the new database file
    • enable the LSCopy job

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Thanks for you reply

    Are there no other alternative to this.

    Regards
    Durai Nagarajan

  • durai nagarajan (11/4/2013)


    Thanks for you reply

    Are there no other alternative to this.

    You could use a manual log backup instead of a differential and restore WITH NORECOVERY, MOVE.

    The easiest option is to ensure the drives and paths are uniform between the instances in the first place 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Do you want to prepare and execute a manual tSQL script?

    Regards
    Durai Nagarajan

Viewing 6 posts - 1 through 5 (of 5 total)

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