Vincent, Nice Article 🙂

And an excellent discussion posting. We often put on our 'Analyst Hat' and dive into things before we've put on our 'Systems' or 'DBA' hat to actually...

OK, thanks for the additional input. I'll go ahead and test it both ways. I didn't notice a big difference when I did it the first time, so this time...

Whoops! Back again. Good thing we're not brain surgeons :w00t:

Our administrator wants to know why I can't just do this on 2 servers, combining the publisher and distributor. I mentioned...

Roy Ernest (1/20/2009)

---

The first thing that need to be done is to set up the distributor. Actually if you are setting it with defaults and simple replication, just follow the...

Roy Ernest (1/20/2009)

---

...Please keep in mind that the transaction Log will grow when you have the Database set in FULL mode. So take regular transaction Log back ups. If you...

So setting up the initial snapshot should be done during slow/down time?

After that the publishing database should be OK? Or will it continue to take a performance hit from...

Thanks Roy,

Another question; How/Where do I set up the publisher server and distributor server separately? Do I do it from the distributor server? Do I set-up something on the publisher...

DavidB (1/9/2009)

---

However, the greatest caution here is that you are basically doubling your activity for that instance for anything that is being replicated. If you are talking about infrequently used...

Hello,

I'm also in the process of setting up transactional replication for reporting purposes. We have a 188GB DB on SQL 2005. Could you explain a little bit more about the...

Maybe we should be looking at this from the point of establishing and legitimizing IT as an actual profession in our society, like teachers, doctors and engineers.

IT is still...

I also have just seen this message on our test server AND a drive failed over the weekend. Hmmm...

We'll swap the drive this morning and I'll post next week as...

Woohoo! That's what I...

Good morning,

I'm running a similar script and yes, it is WAY better to write your own optimizations. How do you handle the exception when the index contains one of the...

I'd like requiring back-ups, indexes and security. BUt I'm absolutely flexible. If the customer doesn't want to take my recommendations, it just means more work and job security for...

Bill Nicolich (9/17/2008)

---

...If one was willing to do a little looking around for volunteer work locally, one might try looking at some of the essential service providers that always seem...