Add data file in mirroring

  • 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.

  • 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

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

    A couple more references:

    Logshipping here[/url]

    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, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply