Following scenario : #1 is principal , #2 is mirror . #1 loses network connectivity with everybody (i.e. wire gets cut) I decide to force #2 to be a...
Mirroring is available in Standard and Enterprise editions. But, the questions is, do I need Enterprise edition (safety off) or will I be ok with...
I read multiple articles. I can't decide. Production OLTP environment. 300+ tran/sec. 100Mbit fiber two physical locations (principal and mirror)....
I understand that in cluster configurations only basic partitions / disks are allowed. In Sql Server installations, do dynamic partitions suffer...
Yes I am. Let's say i'm performing transaction log backups on distribution database every hour. Distributor fails, and I can't get to the latest...
This is for OLAP. Database size will probably increase 4 times or so. Updates (writes) only at night. selects (reads) mostly during the day)....
I didn't mean stopping replication, but stopping activity on published tables. MS talks about "Quiescing a system". Is this just the precaution to...
It is set to Simple. Should it be changed ? Please advise
When using mirroring , remote distributor must be used. Does replication work automatically with fail over server ? What can I do with Distributor,...
...
How can I have redundant distributor ? It can't be mirrored, clustered solution has storage as point of failure. Also what happens when distributor...
MS article says I need to stop all activity before I do schema changes. Can I stop activity on all peer to peer nodes except one that i'm making...
Our production system will have two MSA70 arrays (plus two disk controllers) with each having 25 disks installed for data files. Other files are on...
Separate names with a comma.
