locked
Mirroring disconnect RRS feed

  • Question

  • Experts,

    In my Prod DB, one of the tables is partitioned.Every time the partition is extended(under the control of application team), additional file groups & data files are getting created.This makes the mirroring status go to disconnected state.

    All I'm doing so far is rebuilding the mirroring.Any suggestion or alternate way to avoid rebuilding the mirroring will be of great help :)

    Regards,

    SQL DBA

    Thursday, January 22, 2015 6:44 PM

Answers

  • You can refer the below link

    http://www.mssqltips.com/sqlservertip/2834/how-to-add-a-database-file-to-a-mirrored-sql-server-database/

    --Prashanth

    Thursday, January 22, 2015 7:13 PM
  • Hello,

    If the file paths aren't the same on each server (for example if the path doesn't exist on the mirror server) then this will break mirroring (and also availability groups!). The fix would be to have the paths the same on both servers.

    -Sean


    The views, opinions, and posts do not reflect those of my company and are solely my own. No warranty, service, or results are expressed or implied.

    Friday, January 23, 2015 6:03 AM
    Answerer

All replies

  • You can refer the below link

    http://www.mssqltips.com/sqlservertip/2834/how-to-add-a-database-file-to-a-mirrored-sql-server-database/

    --Prashanth

    Thursday, January 22, 2015 7:13 PM
  • Hello,

    If the file paths aren't the same on each server (for example if the path doesn't exist on the mirror server) then this will break mirroring (and also availability groups!). The fix would be to have the paths the same on both servers.

    -Sean


    The views, opinions, and posts do not reflect those of my company and are solely my own. No warranty, service, or results are expressed or implied.

    Friday, January 23, 2015 6:03 AM
    Answerer