saidapurs (10/11/2012)
Hi Gila/Perry,One of my great senior asked me below two questions and i gave the answer but he not agree, please response of your view..
1. What are SQL Server Dependency ?
My response :- All objects
2. What are SQL Cluster dependence ?
My Response :- Cluster admin, storage, etc
Thanks & regards
Satish
Right let's be straight are we talking mirroring or clustering here?
saidapurs (10/11/2012)
1. What are SQL Server Dependency ?My response :- All objects
That is not a great response to be fair. At what level are we talking?
You could say that SQL Server depends on Windows, but thats stating the obvious.
Are you referring to a clustered or non clustered instance of SQL Server?
saidapurs (10/11/2012)
2. What are SQL Cluster dependence ?My Response :- Cluster admin, storage, etc
A clustered instance of SQL Server typically has the following resources
The virtual name is dependant upon the virtual IP
The SQL Server service is dependant upon the disk and network name resources
The SQL Server agent is dependant upon the SQL Server service
Draw this out diagrammatically and you'll have yourself a small tree 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉