InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 20:33:13 GMT20http://www.sqlservercentral.com/Forums/Topic1371261-1549-1.aspx[quote][b]saidapurs (10/11/2012)[/b][hr]Thanks Pretty, Really i am not aware of first question, he just asked... even i am not sure Mirror or cluster also.Thanks Satish[/quote]Essentially, a mirror instance of SQL Server has the same dependencies as a non clustered instance (ignoring the mirrorred partner part of the equation)Dependencies for a non clustered instance of SQL Server are pretty much taken care of by the OS.[ul][li]a valid computername[/li][li]a valid IP address[/li][li]disk(s) where the sql server binaries and data files are stored[/li][/ul]At the service level in Windows the SQL Server agent depends upon the SQL Server service.Now start throwing in AlwaysOn groups or AO groups and FCIs then you have a real headache for dependencies ;-)Thu, 11 Oct 2012 06:55:55 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1371261-1549-1.aspxThanks Pretty, Really i am not aware of first question, he just asked... even i am not sure Mirror or cluster also.Thanks SatishThu, 11 Oct 2012 06:47:39 GMTsaidapurshttp://www.sqlservercentral.com/Forums/Topic1371261-1549-1.aspx[quote][b]saidapurs (10/11/2012)[/b][hr]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 objects2. What are SQL Cluster dependence ?My Response :- Cluster admin, storage, etcThanks & regardsSatish[/quote]Right let's be straight are we talking mirroring or clustering here?[quote][b]saidapurs (10/11/2012)[/b][hr]1. What are SQL Server Dependency ?My response :- All objects[/quote]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?[quote][b]saidapurs (10/11/2012)[/b][hr]2. What are SQL Cluster dependence ?My Response :- Cluster admin, storage, etc[/quote]A clustered instance of SQL Server typically has the following resources[ul][li]Virtual IP address[/li][li]Virtual Network name[/li][li]clustered disk resources[/li][li]SQL Server instance service[/li][li]SQL Server instance agent service[/li][/ul]The virtual name is dependant upon the virtual IPThe SQL Server service is dependant upon the disk and network name resourcesThe SQL Server agent is dependant upon the SQL Server serviceDraw this out diagrammatically and you'll have yourself a small tree ;-)Thu, 11 Oct 2012 06:43:56 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1371261-1549-1.aspx[url]https://www.google.com/search?q=SQL+Server+dependencies[/url][url]https://www.google.com/search?q=cluster+dependencies[/url]If you're unsure after reading through, please ask.Thu, 11 Oct 2012 04:39:40 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1371261-1549-1.aspxHi 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 objects2. What are SQL Cluster dependence ?My Response :- Cluster admin, storage, etcThanks & regardsSatishThu, 11 Oct 2012 03:56:45 GMTsaidapurshttp://www.sqlservercentral.com/Forums/Topic1371261-1549-1.aspxyes, the article details that.Thu, 11 Oct 2012 03:47:23 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1371261-1549-1.aspxThanks Gila, I read the article and as per my understand through Transaction log data will flow to mirror server. Please let me know if i wrong...Thanks & regardsSatishThu, 11 Oct 2012 03:40:16 GMTsaidapurshttp://www.sqlservercentral.com/Forums/Topic1371261-1549-1.aspx[url]http://msdn.microsoft.com/en-us/library/ms189852%28v=sql.105%29.aspx[/url]Thu, 11 Oct 2012 02:17:03 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1371261-1549-1.aspxHi All, Some one asked me he configured mirroring both servers are in different location and mirroring is working fine..1. How data will move from primary server to mirror server?Thanks & regardsSatishThu, 11 Oct 2012 02:06:43 GMTsaidapurs