Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DB Mirroring fails due to different file locations in Mirror Expand / Collapse
Author
Message
Posted Sunday, June 9, 2013 9:22 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, June 12, 2014 1:09 AM
Points: 72, Visits: 251
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?
Post #1461375
Posted Monday, June 10, 2013 4:43 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, August 29, 2014 9:57 AM
Points: 6,304, Visits: 13,601
detailed here

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1461472
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse