Grant Fritchey (2/15/2011)

---

David Benoit (2/15/2011)

---

Grant Fritchey (2/15/2011)

---

Oh crud, and this is the point where I should have mentioned that my company has a couple of excellent backup compression products you...

Grant Fritchey (2/15/2011)

---

Oh crud, and this is the point where I should have mentioned that my company has a couple of excellent backup compression products you might want to take...

I like the Red-Gate tool as well due to the alerts that it provides. I also like, and use, SQL Sentry, which in my opinion has the best disk views...

...and you might try to lobby for some backup compression software in there somewhere as well. That will save a whole lot of disk space with 3 days of database...

If you could provide table definitions and some sample data inserts that would be helpful. I'm sure that we can help with the query if you provide that.

Thanks.

cjohn5552 (12/30/2010)

---

One thing I was wondering is if the distribution agents continue attempting to apply the commands that yielded the errors, and skipping the errors. Is this the case, and,...

Have you determined how much of the IO / what percentage of IO is tempdb related? If it is high then it might be a quick fix but it is...

Please not - BIG disclaimer - FLASHING - I don't believe this is supported. Read and apply at your own risk....

http://nyc-dba.blogspot.com/2008/10/using-local-disks-in-cluster.html

The key pieces of information are in the comments section....

There is a registry modification / hack that I found some time ago that gives instructions on how to do this, primarily so that SSD's can be used for tempdb...

I know that it can be a fix for some situations but I don't believe it is recommended to be applied universally from what I have read up to this...

Alen - do you have any MS articles supporting that? Curious as I have not...

I haven't taken any exams so I can't answer the question that you are asking. However, I would recommend learning the commands that go along with the GUI as I...

You really should leave a minimum of 2 GB of memory for the OS on any server so, you have most likely depleted the system memory.

I would start lobbying...

You either have to add them to the existing publication (more complex) or add them to a new publication. If you add them to a new publication you can easily...

The table you are going to want to hit is on the distribution database, MSdistribution_agents. To see all the publications you can either look in the distribution database or in...