MSSQL High Aviabalability questions?
Posted on 2012-03-28
We are using MS SQL 2008 with R2 in Windows 2008 server
1). I am planing to implement HA to my company. I know in MS SQL, we can do mirroring, log shipping and replication. Can someone tell me what is the difference among them? What advantages and disadvantages for them?
2). Can we do replication for system database? what is the per-requsite for doing transaction replication?
3). After the log shipping is done, can we create tables or add field to table in standby server. Do it cause the log shipping job down if I do so?
4). What mode should I use when doing log shipping?