I should point out, it requires disk mirroring software of some kind.

Bernardinho (1/5/2012)

---

Perry Whittle (12/19/2011)

---

a replicated database cannot really be considered a true 100% copy of your original database, what if a connection needs to use an object you have not...

In a high volume and perfmormance environment I look to this article a fair bit.

Take it with a pinch of salt and this is based on top end hardware being...

Koen Verbeeck (1/4/2012)

---

Allright, I missed a few weeks of the thread because my wife gave birth to a wonderful son. (and thus killing my regular sleeping pattern)

Did I miss anything...

Roy Ernest (1/5/2012)

---

You do not have to create / modify every object by hand on your subscribers when using Transactional replication. When creating a new table, just add one more...

There are example recursive CTE's all over the web.

A near identical example is on the Microsoft website. This smells like homework 😀

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

Gone are the days I thought 25GB was large. I have a LOT of tables bigger than that.

Agree with the above. I would look at partitioning to add...

derekr 43208 (1/4/2012)

---

MysteryJimbo (1/4/2012)

---

Thats not possible from the job itself. I would create a stored procedure to do what you are after and include the results in an attachment...

Apart from the general issues in Windows 2003 etc this issue I got in 2008r2 convinced me to configure it manually after taking everything into consideration

http://support.microsoft.com/kb/979149

My symptoms werent 100% in...

Thats not possible from the job itself. I would create a stored procedure to do what you are after and include the results in an attachment using database mail.

You'll...

Its...

Suresh B. (1/4/2012)

---

No. Secondary database can be accessed (read-only) during log-shipping.

mitch.fh (1/4/2012)

---

I...

I like to think of business intelligence as an oxymoron

Ahhh

Ninja's_RGR'us (1/3/2012)

New year has nothing to do with his incompetence (ignorance) and his not following strict orders. That server is on total lock down and it requires 3 people's...