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

Logshipping Expand / Collapse
Author
Message
Posted Tuesday, February 16, 2010 3:27 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 18, 2013 9:50 PM
Points: 119, Visits: 650


Hi all,

In QA I recently added a new ndf to one of the DB involved in Logshipping and it break the logshipping.

Again i have sync up the data with a full DB backup and restore.

Can any one please let me know why it breaks the log shipping.

Also i'm curious to know whether the same will work for mirroring or it will break the mirroring also.





Regards,
Sandhya.
Post #866531
Posted Tuesday, February 16, 2010 6:00 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:22 PM
Points: 2,881, Visits: 3,078
Adding a secondary data file will not break mirroring as long as you have the same folder structure on the mirror server.

For example adding datafile2.ndf:

Add datafile2.ndf to C:\Data\ on primary and C:\Data\ exists on mirror everything is fine.

Add datafile2.ndf to C:\Data\ on primary and C:\Data\ does not exist on mirror, then mirroring will be suspended until the directory is created on the mirror side, then you will have to manually resume mirroring.
Post #866639
Posted Wednesday, August 14, 2013 12:13 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, August 14, 2013 4:09 AM
Points: 82, Visits: 4
When you try to add the Secondary file in the Primary Database it goes into suspect mode. Why because what ever you have to perform any transaction in Primary Database internally same transaction try to run in the Mirror Database. In mirror database also try to add the secondary file , but that folder exits the same file of Primary.
SO mirroring is not support the filestream.

Please guide me if i am worng..
Post #1484082
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse