Forgot. Biggest DB is 4TB and an average DB size is around 300GB

Thats around my average per second value.

Avg: approx 2000 tps

Peak: approx 12000 tps

Peak time is normally mid to late afternoon and low time is very early morning.

Completely off the walll and not what I would do, but you could start SQL Agent job with powershell steps from a stored procedure.

I would add the DR server as a 3rd node on your cluster (geo cluster) and yes this is very possible.

Better memory management and Geo Clustering are two improvements that stick out in my mind.

DBA-640728 (12/1/2011)

---

hello guys, i currently have a transactional replication set up with 100 articles. I am adding a few columns to some of the articles, my question is...

I'd...

Assuming this is a Active Directory user you shouldnt need to do this at all.

All logins are based on SID's and the with AD users this comes straight out of...

To remain neutral ...

Other data comparison tools are available.

I know its correct, thats why i said it. ...

This has an impact on replication as well.

I would set up a 5 (or less) minute transaction log back up and rather than deleting all the rows in one go....

Dev (11/28/2011)

---

I usually avoid the discussions when it turns to DBA Vs DEV (developers, not me ;-)). I do understand DBAs are last line of defence but why...

crazy4sql (11/25/2011)

---

Do you intend to continue using the existing VM and is there space for the mdf's?

If so, you should be able to copy them locally and detach/attach the database...

Do you intend to continue using the existing VM and is there space for the mdf's?

If so, you should be able to copy them locally and detach/attach the database again...

GilaMonster (11/24/2011)

---

logicinside22 (11/23/2011)

---

Hi folks,

I have to keep report server real time updated with prodcution server databse . would like to know the suggestions which HA option is...