• 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[/url].

    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[/url]

    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