What is the logic behind keeping Non-Clustered with Primary and Clustered with Secondary?

Steve

I have read some emphasis to take out all clustered index into .ndf; some take all non-clustered into ndf. I guess what you saying is regardless of C or NC,...

The goal is, I want to separate the index and data files on separate drives, for I/O performance issues. Right now, there is only one data file and one log...

I also have access to the cluster's other SQL Group instance's server; will that help in any way?

I confirmed that the SQL Error Log is in the data drive, from the server's event application log.

"Could not open error log file 'I:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'. Operating system error =...

This was the first failure error I see in Cluster log..

00000b14.00000bb4::2009/10/05-17:24:32.721 INFO [FM] FmpHandleResourceFailure: taking resource adca9ab1-56de-484b-88b1-42dd21d4e849 and dependents offline

000006c4.00000c2c::2009/10/05-17:24:32.721 ERR SQL Server Agent <SQL Server Agent >: [sqagtres]...

Matt

the tempDB issue was powerful enough to knock out the cluster drives.

Any thoughts how to restore it back from Cluster Administration?

thx

Dan

Gail

These are the 3 repeated errors in the logs..

The SQL Server (SIS008) service terminated with service-specific error 17058 (0x42A2).

Cluster resource in Resource Group failed.

The SQL Server (SIS008) service terminated with...

The error from the log is

http://msdn.microsoft.com/en-us/library/aa258778%28SQL.80%29.aspx

Bbut I am not sure how to free that 2MB Space.

Also want to add that this is on a Cluster, and the 35GB data Drive and the other ones also are in offline/failed state.

Hi

I divided the TempDB into 8 files.

I modified the location for the 8 files. The new drive totally assigned to TempDB is 35GB, so I broke each file into 4587520KB...

Glenn

What about I/O? Do the users see slow responses? Why did you not consider a separate server or a different model like Snapshot replication etc.

I see you gained in...

oops.. my fault.. I misread and said yes to 'truncation of log ... after backing up the log' missing the what in the front.

Let me explain.

The maintenance plan first runs...

Glenn

Thanks for stressing the importance of watching the log and data file sizes. If you have a tSQL code for this that does a good job, kindly share. If not,...

Marcin

I should have asked if it was from Kim's experience or is it a MS reco? If you have the link for that, kindly share.

Dan