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...

I was about to ask that question. My server guys just gave me a funny look when I asked them. @=)

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...

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

The Spartans (3/29/2011)

---

Hi,

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...

CirquedeSQLeil (3/28/2011)

---

This is a nice example of a...

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,...

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...

Hmm. Point taken. I can see that working.

GilaMonster (3/28/2011)

---

That's actually very simple.

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,...

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...

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...

[Jim].[dba].[Murphy] (3/27/2011)

---

Also, even though tempdb is recreated each time SQL Server starts, unlike a brand new user database, the new tempdb file settings, including it's size is taken from...

Sachin Nandanwar (3/28/2011)

---

But just one last confusion if you can clear me on that.When the data is written to the disk in middle of a transaction and a checkpoint occurs...

DOH. I knew there was a reason I asked this question and I got so caught up in getting my DDL together that I forgot the most important part.

Rephrase: Not...