DB Mirroring fails due to different file locations in Mirror

• Mohammed Imran Ali

  SSCrazy

  Points: 2125

  More actions

  June 9, 2013 at 9:22 pm

  #394935

  Hi,

  I have a DB Mirroring configuration where the physical files are located in different logical directories(Data file locations).

  Principal : F:\DBData\DB1\

  Mirror : E:\DBData\DB1\

  One of the databases creates a new datafile (xxx_ddmmyy.ndf) every week. After this operation completes on the Principal, the Mirroring goes suspended. Is there a work around to this apart from changing the drive letters?

• Perry Whittle

  SSC Guru

  Points: 233821

  More actions

  June 10, 2013 at 4:43 am

  #1622372

  detailed here

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

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