Post reply

Logshipping to another server with different drive names

  • October 30, 2013 at 11:29 pm

    #300603

    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

  • November 3, 2013 at 11:41 am

    #1663676

    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" 😉

  • November 4, 2013 at 4:06 am

    #1663766

    Thanks for you reply

    Are there no other alternative to this.

    Regards
    Durai Nagarajan

  • November 4, 2013 at 5:06 am

    #1663781

    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" 😉

  • November 5, 2013 at 2:13 am

    #1664064

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

    Regards
    Durai Nagarajan

  • November 5, 2013 at 4:56 am

    #1664097

    Yes, Perry means so.

    http://ask.sqlservercentral.com/questions/4065/adding-a-datafile-to-a-log-shipping-primary.html

    http://ramaudaya.blogspot.com/2011/09/adding-additional-datafile-to-primary.html

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

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