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