imilikic (11/21/2011)

---

Jim ,

Thanks for your quick response.

I agree with you that this is not maybe what I need. I am new in this field.

What you should know is that...

I would blow a gasket if they said...

LOL! While I appreciate that, cost is not my concern - performance is for sure. So if it costs me money to get something that will do the...

What about using something like RedGate's SQL Monitor? I have an off-shore resource that I can task with these...

Yeah well I don't have the disk space to allow 150+ DBs to have log files that just grow and grow (I have some that end up 2 or 3...

I really don't think you need what you think you need. Sounds like your transaction log file keeps growing and you don't know how to stop that except by...

And the RTO/RPO is what the contract specifies so that's the minimum. I think the 15 min RPO is good - I'm shooting for a <= 2 hr RTO...

GilaMonster (11/18/2011)

---

christopher.metzger (11/18/2011)

---

Whether it should be log shipping from VA to CA or if I can do another mirror so the SQL Server on the other end is more easily...

And no - the primary mirror will not have all DBs mirrored to one instance. They will be mirrored on a per instance basis. So yes the primary...

The environ is vCloud with SQL 2008 R2 Enterprise. Most instances may only have a handful of databases (an ASPState, a tiny Security, a facility - which can get...

Yeah so not going to mirror at the SAN - the traffic/bandwidth requirements to mirror that clear across the country to another datacenter, not to mention the costs involved, isn't...

Thanks! So I assume I would need to use the SQL Server Config Manager to specify what port each instance uses correct (looks like there is a how to...

I know this is an older thread but it is the BEST article I have found that somewhat covers what I'm attempting to do. Now I freely admit I...