locked
database mirrioning RRS feed

  • Question

  • Hi all,

    i have one doubt in database mirroring......

    log shipping work based on this jobs like

    backup job

    copy job 

    restore job

    like which based on  database mirroring works internal in ms sql server

    please give details answer

    thanks

    naga

    Thursday, March 14, 2013 3:02 PM

Answers

  • You should read this topic, which gives a pretty good overview.  Basically, each transaction on the source server is sent to the mirror server, thus keeping that copy up-to-date with the original.  The mirror database will be in recovery mode since it is constantly recovering transactions from the source server.

    http://msdn.microsoft.com/en-us/library/ms189852(v=sql.105).aspx

    It is really simple in the basic description.  It just gets complicated when there are problems.

    RLF

    Thursday, March 14, 2013 7:06 PM