locked
log shipping RRS feed

  • Question

  • what is monitor server? How it can be help ful to the log shipping? i need simple answer... plz reply me that
    Thursday, July 1, 2010 3:29 AM

Answers

  • Monitor Server

    The optional monitor server tracks all of the details of log shipping, including:

    ·                      When the transaction log on the primary database was last backed up.

    ·                      When the secondary servers last copied and restored the backup files.

    ·                      Information about any backup failure alerts.

    The monitor server should be on a server separate from the primary or secondary servers to avoid losing critical information and disrupting monitoring if the primary or secondary server is lost. A single monitor server can monitor multiple log shipping configurations. In such a case, all of the log shipping configurations that use that monitor server would share a single alert job.

     

    Note: Once the monitor server has been configured it cannot be changed without removing log shipping first.

    -------------------------------

    Thanks,

    RajaSekhar Reddy .K

    Thursday, July 1, 2010 4:22 AM
  • you will get the information about this from the http://msdn.microsoft.com/en-us/library/ms187103.aspx


    HTH Thanks, Narendra Angane
    Thursday, July 1, 2010 1:46 PM

All replies

  • Monitor Server

    The optional monitor server tracks all of the details of log shipping, including:

    ·                      When the transaction log on the primary database was last backed up.

    ·                      When the secondary servers last copied and restored the backup files.

    ·                      Information about any backup failure alerts.

    The monitor server should be on a server separate from the primary or secondary servers to avoid losing critical information and disrupting monitoring if the primary or secondary server is lost. A single monitor server can monitor multiple log shipping configurations. In such a case, all of the log shipping configurations that use that monitor server would share a single alert job.

     

    Note: Once the monitor server has been configured it cannot be changed without removing log shipping first.

    -------------------------------

    Thanks,

    RajaSekhar Reddy .K

    Thursday, July 1, 2010 4:22 AM
  • you will get the information about this from the http://msdn.microsoft.com/en-us/library/ms187103.aspx


    HTH Thanks, Narendra Angane
    Thursday, July 1, 2010 1:46 PM
  • Thanks,

     Mr. RajaSekhar Reddy for your help

    Friday, July 2, 2010 3:35 AM