Mirroring doubt

  • Hi 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 & regards

    Satish

  • http://msdn.microsoft.com/en-us/library/ms189852%28v=sql.105%29.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Thanks 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 & regards

    Satish

  • yes, the article details that.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • 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

  • https://www.google.com/search?q=SQL+Server+dependencies

    https://www.google.com/search?q=cluster+dependencies

    If you're unsure after reading through, please ask.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • 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

    • Virtual IP address
    • Virtual Network name
    • clustered disk resources
    • SQL Server instance service
    • SQL Server instance agent service

    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" 😉

  • Thanks Pretty,

    Really i am not aware of first question, he just asked... even i am not sure Mirror or cluster also.

    Thanks

    Satish

  • saidapurs (10/11/2012)


    Thanks Pretty,

    Really i am not aware of first question, he just asked... even i am not sure Mirror or cluster also.

    Thanks

    Satish

    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.

    • a valid computername
    • a valid IP address
    • disk(s) where the sql server binaries and data files are stored

    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 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply