Viewing 15 posts - 6,166 through 6,180 (of 9,722 total)
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
Gail gave you all the code you need. Now you have to create a job with a T-SQL task. Do you have any other DBAs on the team that can...
March 28, 2011 at 8:10 am
GilaMonster (3/28/2011)
Set up a SQL Agent job scheduled to run at midnight. The job step needs a single line of T-SQL
DBCC CHECKIDENT (CALLS, RESEED, 0)
Needless to say,...
March 28, 2011 at 7:53 am
Here's an article link on how you can post your code (and questions) so we have enough information to assist you.
http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D
Your question doesn't sound very complex, but it would help...
March 28, 2011 at 6:04 am
I hate to say it, but this might be a case of "Call Microsoft." I certainly can't think of why your connection would fail out of the blue if nothing...
March 28, 2011 at 5:12 am
Viewing 15 posts - 6,166 through 6,180 (of 9,722 total)