Official doesn't necessarily mean anything. Do you want something from Microsoft? From a government agency?

Here is an old doc from the NSA:

http://www.nsa.gov/ia/_files/db/mssql_2k.pdf

I think most of the...

You "can", but you take a hit on performance and security.

Performance because you will be sharing resources between all three systems on one box.

Security because you open your server up...

No luck so far. I have tried a few different permutations, but the queue reader persists.

I'll keep poking around and see what I find, but I am less worried...

Gail,

Your steps worked like a charm!

Incidentally, I ran sp_repldone as follows:

exec sp_repldone null,null,0,0,1

Once I executed this, DBCC Opentran no longer included the distribution info.

And, once I deleted the transactional...

Thanks for the question. I was ticked since I got it wrong, but it is too easy to just gloss over a script when reading it. A good...

bluefox,

Is it [testdb] that is mirrored? What happened that caused the autogrow to fail?

What is the growth increment on the tlog? How much space is left on the...

Paul,

I agree with everything you wrote except for the surprise. I have run into this too many times, mostly on workstations, where either users or some software has been...

Heh... now I remember why this is snapshot.

It is a PeopleSoft database and PeopleSoft doesn't use or support explicit primary keys. Sigh.

So scrap what I said about...

...Can running the log reader cause problems with snapshot publications?

No, I don't think so... Not yet at least.

Is it possible there is an orphan somewhere?

I have poked around a bit in the distribution database but nothing...

Noone? 😀

Well I am not willing to risk it, so for now I will leave the Log Reader Agent running. Doesn't seem to be causing any performance issues. ...

Grant,

Would the default trace be a good choice here to persist data across restarts?

-Dan B

Yow... Good question.

Should have listened to my gut instinct on reading "do not run it on production server" 🙂

I'll parrot the thanks. Good question and good examples which I definitely needed.

-Dan B