Viewing 15 posts - 6,151 through 6,165 (of 9,715 total)
ALZDBA (3/29/2011)
Did you try dtcping and dtctester?
Hadn't heard of those tools until you told me about them. I'll check into them. Thanks for the link.
Did someone alter DNS settings, firewall...
March 30, 2011 at 5:47 am
Sorry it took so long. Had fires to put out.
SELECT srsf.DTConID, srsf.CNum,
CASE WHEN srsf.TransactionDate >= srsf.CycleStartDate AND srsf.TransactionDate <= srsf.CycleEndDate
AND pr1.DTConID IS NULL AND srsf.Status NOT...
March 30, 2011 at 5:00 am
Thanks, Perry, but MSDTC is running as a clustered resource (I thought I mentioned that in my first post, but upon re-reading, I apparently phrased the sentence in vague terms)....
March 29, 2011 at 12:46 pm
Alzdba, Thanks for the links. I've seen a few of them before, but the one on tracing is new and I might just have to do that.
March 29, 2011 at 12:03 pm
Perry Whittle (3/29/2011)
March 29, 2011 at 11:46 am
Rhox (3/29/2011)
Why should you use this command for?
Honestly, I wouldn't use this command. I can't think of one good reason why I would need it in any production environment I...
March 29, 2011 at 11:41 am
Further information (which just goes to prove that even informational messages in the logs can be helpful):
Application Log Informational Message
Event Source:MSSQL$ACP1
Event Category:(2)
Event ID:8562
Date:3/28/2011
Time:8:51:33 PM
User:N/A
Computer:XXXXXXXXXXXXXX
Description:
The connection has been lost with...
March 29, 2011 at 9:18 am
GilaMonster (3/29/2011)
Brandie Tarvin (3/29/2011)
The command being discussed has the effect of turning the database (temporarily) to SIMPLE mode because it throws out the transaction log backup
No it doesn't. It...
March 29, 2011 at 8:25 am
ALZDBA (3/29/2011)
Other Q may be:- is this only to a single node or does it happen with all nodes ?
Sometimes it's just the node that MSDTC is attached to. Sometimes,...
March 29, 2011 at 8:24 am
Rhox (3/29/2011)
And can we use this command on a mirrored db?Or do we need to take other actions to shrink the log-file of a mirrored db?
I'm curious where you got...
March 29, 2011 at 8:20 am
Tom.Thomson (3/29/2011)
Ray K (3/29/2011)
Peter Trast (3/28/2011)
'Spensive-- Ricky Ricardo
LUUUUUUUUUUUU-CYYYYYYYYYYYYY!!!
DIAMONDS
Sky
March 29, 2011 at 8:17 am
The cluster log is too full to have any data from last night's failure. All I'm getting is today's "Looks Alive" comments.
Is there someplace I can set up the cluster...
March 29, 2011 at 8:16 am
ALZDBA (3/29/2011)
C:\WINDOWS\Cluster\cluster.log
I was about to ask that question. My server guys just gave me a funny look when I asked them. @=)
March 29, 2011 at 8:13 am
Ah, I suppose that would help, wouldn't it? @=)
Windows 2003, up to date on Service Packs (so far as we know, but this is administered by a corporate office).
It's an...
March 29, 2011 at 8:07 am
All,
I'm having a bit of a cluster issue. Would love advice from people with cluster experiences, if you have time.
http://www.sqlservercentral.com/Forums/Topic1085532-146-1.aspx
March 29, 2011 at 7:58 am
Viewing 15 posts - 6,151 through 6,165 (of 9,715 total)