Error 1067: The cluster service is stopped on passive node of my two node sql cluster. It throws following error when I try to start this:

This is found that the cluster service in one of the passive stops. This throws following error when I try to start this.

Error 1067: The process terminated unexpectedly

I verified the password under which this cluster service is running. This account is perfect. So there should be some other problem.

Let’s go ahead and see the problem in the cluster.log file.

Info from %WINDIR%\Cluster\cluster.log is as follows:

WARN [EVT] EvtBroadcaster: EvPropEvents for node 2 failed. status 1727
WARN [NM] RpcExtErrorInfo: Error info not found.

Error from clusterlog

Error: Failed to read  (sector 12), error 170. and Failed to write  (sector 12), error 170.
1. started from cmd. net start clussvc
2. The Windows Firewall/Internet Connection Sharing service should neither be enabled nor set to start automatically.

FmGetQuorumResource failed, error 170. Failed to read. Failed to form cluster, status 5086.

Follwoing was the problem:

The Admin NIC threw an error. This caused the netowrk connectionos in the cluster disabled. I disabled and enabled the NIC and this started working.

Sql Server Error 8951 Data row does not have a matching index row in the index

Read blog Sql Server Error 8951 Data row does not have a matching index row in the index to understand and resolve this quickly.

Regards,
Online Powershell and SQL Classes @ http://tuitionaffordable.webstarts.com

Arithmetic overflow error converting expression to data type varchar.

Let’s try following command to get this error:

SELECT CAST( CAST(virtual_memory_in_bytes AS VARCHAR(5)) AS DECIMAL(5,2))
FROM sys.dm_os_sys_info

We can fix this using a perfect CAST statement:

select CAST(virtual_memory_in_bytes AS DECIMAL(15,2))/(1024*1024*1024)
from  sys.dm_os_sys_info

 Another Interesting wire: Replication MSSql Error 1088 – Cannot find the object

Regards,
Online Powershell and SQL Classes @ http://tuitionaffordable.webstarts.com

MSSQL Server Error: “Cannot generate SSPI context”

Wrong or stale spn settings cause this error. I got following alert on tow of my servers eg Tuitionaffordable11, Tuitionaffordable23: “Cannot generate SSPI context”. This error emerged when i try to connect these servers just like everyday work from other server. Please read following wire to resolve this error:

MSSQL Server Error: “Cannot generate SSPI context”

Regards,
Online Powershell and SQL Classes @ http://tuitionaffordable.webstarts.com

MSSql Error 1088 – Cannot find the object “tuition_account_info” because it does not exist or you do not have permissions

Following error is a simple and most easily seen error in transaction replication. The solution is also very simple. Read following blog to solve this in minutes.

Regards,
Online Powershell and SQL Classes @ http://tuitionaffordable.webstarts.com

DBCC CheckDB The operating system returned error 21(The device is not ready.)

This error can be very difficult to deal with this error if not dealt properly. Go through following wire carefully

DBCC CheckDB The operating system returned error 21(The device is not ready.)

Regards,
Online MSSQL Classes @ http://tuitionaffordable.webstarts.com

War Room: Read This To Avoid Silly DBA Mistakes

REBUILD INDEX ONLINE OR OFFLINE??

ALTER INDEX ON

REBUILD WITH (ONLINE = ON)
OR
ALTER INDEX ON I am just scared why some DBAs don’t take care of small things. I asked one of my DBA to REBUILD the indexes of a table which is nothing but HBI data. What command will you use doing that? Definately ALTER INDEX ON REBUILD. But wait. Do you think that users would be able to access the table when the rebuild process is going on. Either inform the users that you are going to have the DB offline or do this WITH (ONLINE=ON). Directly applying the REBUILD command can cause a significant outage.Just be careful….it goes like this. If Clustered index is rebuilt OFFLINE then any user won’t be able to access the data of the table on which operation is being performed. The reason is SCHEMA lock on the table. If non clustered index is rebuilt then SELECT query can be performed but any update/insert and delete won’t work. So Just be careful…

INTERVIEW PREPARATION IN 30 MINs - Read Following wires for a quick interview preparation.

1. SQL Server DBA “Interview Questions And Answers”
2. SQL Azure Interview Questions and Answers Part – 1
3. SQL Azure Interview Questions and Answers Part – 2
4. Powershell Interview Questions and Answers

Regards,

Online MSSQL Classes @ http://tuitionaffordable.webstarts.com