Exactly. 🙂

Theres a couple key statements that caught my eye. So going on this limited information i'll try to help.

david.alcock (4/16/2012)

---

Just wondered what would suit a rather common scenario, if...

GilaMonster (4/4/2012)

---

1. Yes, but it's not very useful. If the primary ever fails and you have to switch to the secondary, there will be no way to go back to...

nicoalmontec (4/1/2012)

---

My goal is to reduce address redundancy as much as possible since it is likely that there will be people living in the same address. Both answers seem pretty...

This is what I would do.

Ensure the tables are there. Populate addresses followed by the new people table then rename the old objects.

You arent clear on whether you need...

Sounds like the job is already running.

If it were the logreader I'd suggest it was this proc blocking

http://msdn.microsoft.com/en-us/library/ms186983.aspx

A fairly complicated request. Does all of this infrastructure already exist?

If it doesnt I'd probably suggest merge replication. It'd be a star like topology with the main branch...

Randy Doub (3/29/2012)

---

In my environment,...

IMO you as the DBA shouldnt be told or not. You should be in full control creating and designating servers. Only you will know the load or judge...

Revenant (3/28/2012)

---

The British did...

Disk mirroring is always an "option" and isnt limited to SAN's. Third party software such as Doubletake accomplishes the same.

Yes

Adam Seniuk (3/28/2012)

---

I have been...

Powershell?

MysteryJimbo (3/9/2012)

---

Apart from the syntax, you can achieve the same with both so there's little between them since they both use the same .Net libraries.

vb does have a stigma associated...

Thats pretty vague. Anymore information?