Your theory is sound but DCOM doesn't work that way, unfortunately. What you are referring to is a stateful firewall. What this means is that if server A behind firewall...

Yes, I've seen that article too, and you are right assuming the "server" can freely talk to the "client" on any port. However, the article also states:

You should be...

Ditto. We ran into this where I currently work with a web-based database app. Royal pain in the neck until we figured it out.

Good points.

My manual routine actually ships every 4 hours and will fail if someone is in the database and will try to restore the file that it copied to the...

FOUL! Bad question. 5 yard penalty. Repeat QOD!

Seriously, this isn't a good question because if fails to explain HOW the log shipping is configured. I'm doing log shipping by hand...

Carl,

     I have to wonder if the error has something to do with the SQL Server log and not the Windows log...

    If I could suggest you take a look...

I must take exception with the explanation, actually:

All the T-SQL methods above will work but you cannot tell the version of SQL Server...

Cheers for having the courage to at least submit one and subject yourself to the scrutiny of geeks.

Actually, that wouldn't be correct either, would it? I mean, the correct answer should be:

"The entire transaction log will be applied but the database will be left in a non-recovered...

I guess it would be a matter of degree and the type of database we are talking about.

If this were an OLTP database I would probably agree with you 100%....

Actually, one of the main benefits of the FULL recovery model in SQL 2000 is the ability to restore a transaction log to a point-in-time using the WITH STOPAT option.