Forum Replies Created

Viewing 15 posts - 4,636 through 4,650 (of 9,244 total)

  • RE: Seaparating Data files and Log Files

    chandan_jha18 (11/14/2012)


    Hi Folks,

    I am facing an issue which I thought I understood but looks like reading and implementing a strategy are very different.

    I have a SQL 2008 running on a...

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

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

  • RE: What would be the best RAID configuration for this hardware?

    Controllers and disks differ. The only sure fire way is to create test arrays and spin up SQLIO to test your throughput and latency. Try different arrays and number of...

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

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

  • RE: SQL 2012 multisite cluster

    charmon79 (11/11/2012)


    Perry Whittle (11/9/2012)


    rupengzhao (11/7/2012)


    Hi All,

    With SQL 2012, one can setup multi-site (multi-subnet) failover clusters.

    This is also possible with Windows and SQL Server 2008

    I've been researching this as well for...

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

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

  • RE: What would be the best RAID configuration for this hardware?

    12x600gb is a serious amount of storage, what do you intend to use the new disks for? Have you considered what config you would use if you do split the...

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

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

  • RE: Start Mirroring Failure

    To setup mirroring in a workgroup see this link

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

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

  • RE: SQL Cluster shutdown issue due to network issue

    You can change the actions that are taken during a failover but the default is to try online locally then fail over and try 3 times then offline if unsuccessful....

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

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

  • RE: Windows Cluster Servers Migration

    trayalacheruvu (11/8/2012)


    [font="Verdant"]Dear Friends,

    I need valuable suggestion to do the Servers Migration and SAN relocation in the below scenario:

    SQL Server Setup in Windows Clustering: We are currently running with...

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

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

  • RE: SQL 2012 multisite cluster

    rupengzhao (11/7/2012)


    Hi All,

    With SQL 2012, one can setup multi-site (multi-subnet) failover clusters.

    This is also possible with Windows and SQL Server 2008

    rupengzhao (11/7/2012)


    I wonder if you can have one active node...

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

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

  • RE: SQL Server Cluster 2008 SP1 to SP2 upgrade on Windows 2003 Service Pack2

    Theres no difference. Extract the SP to a location on a fixed drive and not a shared drive. Run the setup program and complete the install. You'll need to do...

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

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

  • RE: SQL Cluster shutdown issue due to network issue

    It should try to start on an available node, if theres an issue with the available node too then the group will stay offline after a certain amount of retries

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

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

  • RE: SQL Cluster shutdown issue due to network issue

    govindarajan69 (11/8/2012)


    Even i have the same understanding that the sql server should not go down due to network issues whether it is private or public.

    No, stop, this is incorrect.

    Kindly...

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

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

  • RE: Kerberos authentication Issue

    CuriousDBA (11/8/2012)


    Yes. we have created SPN for all the servers including Virtual server Name (Cluster)

    what do you mean all servers? The only SQL Server SPNs should be the ones created...

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

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

  • RE: SQL 2012 multisite cluster

    rupengzhao (11/7/2012)


    4 nodes in Site A and 2 nodes in Site B. Can I have 1 active node in Site A and 1 active node in Site B at the...

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

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

  • RE: ReBuilt Index

    Michelle Ufford's script is also very good, you can find it here[/url]

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

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

  • RE: SQL Cluster shutdown issue due to network issue

    Check your windows application and system logs, collate this info with the cluster events log. Can you post details of any errors reported, failure of the public network will initiate...

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

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

Viewing 15 posts - 4,636 through 4,650 (of 9,244 total)