locked
What are management issues when Principal and DR mirroring environments use different drive letters. 2008R2 Enterprise Edition. RRS feed

  • Question

  • I have to build a DR environment. The drive letters on principal are different than I HAVE to use on new DR server. Is 2008R2 mirroring able to handle that difference in drive letters. And what are the complexities for managing this setup and failing over from principal to DR?  Thank you for your reply!
    Wednesday, February 5, 2014 9:18 PM

Answers

  • Hello,

    Drive letter will not affect mirroring.You can use with move option to create DB on Mirror database.In mirrorin transaction log backup is not restored but transactions are replayed so it does not matters drive number for Mirror database.

    Regrading complexity it depens on level of experience.You can search net and find various documents related to Mirroring.One which I always keep handy is

    http://technet.microsoft.com/en-us/library/cc917680.aspx


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    • Proposed as answer by Sofiya Li Friday, February 7, 2014 9:49 AM
    • Edited by Shanky_621MVP Friday, February 7, 2014 9:58 AM
    • Marked as answer by Sofiya Li Thursday, February 13, 2014 9:21 AM
    Wednesday, February 5, 2014 9:42 PM

All replies

  • You can handle database Mirroring with difference in drive letters.

    The mirroring is not centralized on drive letter but there will be some issues when you add a file to a PRINCIPAL, the DDL gets applied across mirror, then your database will go into suspended status until you duplicate the path on the mirror.

    Its recommended to have same identical configuration.

    You can refer the below link 

    http://www.extremeexperts.com/sql/articles/DBMirroring2.aspx

    http://blogs.msdn.com/b/suhde/archive/2009/07/13/step-by-step-guide-to-configure-database-mirroring-between-sql-server-instances-in-a-workgroup.aspx

    http://sqlserverperformance.wordpress.com/2012/03/12/sql-server-database-mirroring-tips-and-tricks-part-1/

    -Prashanth


    Wednesday, February 5, 2014 9:40 PM
  • Hello,

    Drive letter will not affect mirroring.You can use with move option to create DB on Mirror database.In mirrorin transaction log backup is not restored but transactions are replayed so it does not matters drive number for Mirror database.

    Regrading complexity it depens on level of experience.You can search net and find various documents related to Mirroring.One which I always keep handy is

    http://technet.microsoft.com/en-us/library/cc917680.aspx


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    • Proposed as answer by Sofiya Li Friday, February 7, 2014 9:49 AM
    • Edited by Shanky_621MVP Friday, February 7, 2014 9:58 AM
    • Marked as answer by Sofiya Li Thursday, February 13, 2014 9:21 AM
    Wednesday, February 5, 2014 9:42 PM