Sep 27, 2017

Not able to start SQL Server Services, what may be the reasons and how will you troubleshoot?


There are some basic reason if you not able to start the SQl Server Service:
1)     Master db files are not found on their location or corrupted

2)     Instance specific binaries or related binaries are either corrupted or disk is not available.

3)     Registry may be corrupt;

4)     Permissions may be messed up

5)     Antivirus may block the services to start

6)     Memory is not sufficient on server to allocate to SQL Server that time.


You can Troubleshoot the issue using following way:

1)     Check the SQL Server error log if created in instance root directory in Log folder

2)     Application and System logs in event viewer log

3)     Check resource (Memory and CPU) utilization on server that time.

4)     Check if relevant disks where SQL Server binaries located are attached/accessible from server

Whats a TUF File and where its located in sqlserver ?


Transaction Undo File: which is created when performing log shipping to a server in Standby mode.

And this will be on standby server.

How many IP addresses are required for 3 nodes cluster?


2 IPs required per node (Private and Public)

1 Windows Cluster

1 per SQL Instance + MSDTC

         MSDTC was must in Windows Server 2003 if used by instance but Windows 2008         onwards it can use from local service on node while for best practice it should be separate for each instance.