· Database mirroring is fully supported on standard, developer and enterprise edition.
· We need the principal and mirror server. Witness is a option in our case we can keep it as manual changeover.
· Operation can be synchronous (obviously adds some latency cost to complete transaction across two servers --- advantages high availability and high protection)
o or asynchronous( more speed – high performance - without waiting for mirror to write on the log)
· sql server instances should be of same service pack
· verify we have the enough disk space where the mdf and ldf is stored on the both the servers
· the principal database should be on FULL database recovery mode
· please note all transactions are written to transaction log and not truncated
No comments:
Post a Comment