locked
log shipping RRS feed

  • Question

  • Adding new file on the primary in log shipping, what happens secondary?
    Friday, October 8, 2010 5:29 PM

Answers

  • Hi sql serevr dba, 
    Adding new file on the primary in log shipping, what happens secondary?
    Based on my test, if we add new file on primary, the log shipping will work incorrectly and this file is missing in secondary database.
    Therefore if you want to add a new file to the primary database, I would like to recommend that you reconfigure the log shipping.
    If anything is unclear, please let me know.


    Regards,
    Tom Li


    Thanks incorrect!!!  Refer http://support.microsoft.com/kb/286280 (Description of the effect to database recovery after you add or remove database files)


    Balmukund Lakhani | Please mark solved if I've answered your question
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Monday, October 11, 2010 12:46 PM

All replies

  • Hi sql serevr dba,

     

    Please refer to the link provided by Balmukund below.

     

    If anything is unclear, please let me know.


    Regards,
    Tom Li
    Monday, October 11, 2010 12:39 PM
  • Hi sql serevr dba, 
    Adding new file on the primary in log shipping, what happens secondary?
    Based on my test, if we add new file on primary, the log shipping will work incorrectly and this file is missing in secondary database.
    Therefore if you want to add a new file to the primary database, I would like to recommend that you reconfigure the log shipping.
    If anything is unclear, please let me know.


    Regards,
    Tom Li


    Thanks incorrect!!!  Refer http://support.microsoft.com/kb/286280 (Description of the effect to database recovery after you add or remove database files)


    Balmukund Lakhani | Please mark solved if I've answered your question
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Monday, October 11, 2010 12:46 PM