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

Add data file in mirroring Expand / Collapse
Author
Message
Posted Saturday, March 23, 2013 6:02 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, August 14, 2014 7:58 AM
Points: 139, Visits: 402


Here i have configured the mirroring. after that i want to add the data file to primary.

can we add the data file?

if we add is there any impact on mirror server and those data file will be add in mirror server or

here both principal and mirror are in synchronization mode.

same is it possible to add in log shipping also. is there any impact on it.

please provide the procedure.
Post #1434595
Posted Saturday, March 23, 2013 7:55 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:44 PM
Points: 7,107, Visits: 12,661
gantavasu (3/23/2013)


Here i have configured the mirroring. after that i want to add the data file to primary.

can we add the data file?

if we add is there any impact on mirror server and those data file will be add in mirror server or

here both principal and mirror are in synchronization mode.

As long as the file paths exist on both the principal and mirror server you can add the new data file to the principal and it will be created on the mirror. If the file path does not exist on both then see this article.

same is it possible to add in log shipping also. is there any impact on it.


Adding an additional data file to a log shipped database
Add data file to primary database in log shipping

You might try Bing or Google next time. There are plenty of articles about these topics...


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1434611
Posted Saturday, March 23, 2013 8:47 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:05 AM
Points: 17,710, Visits: 15,580
opc.three (3/23/2013)
gantavasu (3/23/2013)


Here i have configured the mirroring. after that i want to add the data file to primary.

can we add the data file?

if we add is there any impact on mirror server and those data file will be add in mirror server or

here both principal and mirror are in synchronization mode.

As long as the file paths exist on both the principal and mirror server you can add the new data file to the principal and it will be created on the mirror. If the file path does not exist on both then see this article.

same is it possible to add in log shipping also. is there any impact on it.


Adding an additional data file to a log shipped database
Add data file to primary database in log shipping

You might try Bing or Google next time. There are plenty of articles about these topics...


A couple more references:
Logshipping here

Mirroring [ur=http://jasonbrimhall.info/2012/04/02/move-the-t-log-file-of-the-mirror-database/l]here[/url]

Last note: The article on mirroring by Perry has a slight error in the restore script. It is obvious that he meant to restore that on the MIRROR by the path used. But he referenced the wrong drive. Just check that when using that example so as to avoid some confusion.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1434618
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse