Viewing 15 posts - 6,151 through 6,165 (of 9,714 total)
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
The Spartans (3/29/2011)
i have created the Log Shipping in my system.it taking backups of transaction logs and working fine and in the secondary server the backups are not moving and...
March 29, 2011 at 7:56 am
CirquedeSQLeil (3/28/2011)
GilaMonster (3/28/2011)
Not trying to start any bashing or pile-ons, but this has to rate high on the list of most useless replies: http://www.sqlservercentral.com/Forums/FindPost1084783.aspx
This is a nice example of a...
March 28, 2011 at 9:34 am
I recommend adding logging to the SQL Job.
Edit Step 1 and highlight Advanced on the left. It'll change from the code screen to the advanced screen.
In the Output File box,...
March 28, 2011 at 9:15 am
Viewing 15 posts - 6,151 through 6,165 (of 9,714 total)