Forum Replies Created

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

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

  • RE: check diskspace

    The best way is to use a simple WMI query as follows

    wmic volume get capacity, "free space", name

    If xp_cmdshell is disabled you can turn it on first then disable it...

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

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

  • RE: Kerberos authentication Issue

    you created the SPNs for the virtual network name against the sql server service account?

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

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

  • RE: differential backup question

    Unless arcserve is doing something different like snapshotting disk files.

    Differential bitmaps are reset by a full backup in SQL server.

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

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

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