Forum Replies Created

Viewing 15 posts - 4,501 through 4,515 (of 9,253 total)

December 5, 2012 at 2:04 am

#1565612

  • RE: SQL Cluster question

    Mh-397891 (12/4/2012)

    We have a cluster named Cluster1 which is a single node cluster. It has SQL Server 2008R2 Enterprise edition installed on it.

    And we have another cluster Cluster2 which is...

    December 5, 2012 at 2:00 am

    #1565608

  • RE: 6 NICs for a Cluster?

    They read the MS kb did they 😀

    December 4, 2012 at 2:19 pm

    #1565501

  • RE: 6 NICs for a Cluster?

    Ok but generally you would want at least 2 or 3 NICs teamed for your public connection to provide redundancy.

    December 4, 2012 at 11:50 am

    #1565457

  • RE: 6 NICs for a Cluster?

    Have you used network teaming before??

    December 4, 2012 at 8:48 am

    #1565380

  • RE: Reduce size of BAK file after deleting database table records?

    Can you post the table definitions for the tables you are deleting from?

    December 4, 2012 at 5:46 am

    #1565247

  • RE: 6 NICs for a Cluster?

    sql-lover (12/3/2012)

    -We are using cross over cable for heartbeat

    As i said a segregated network

    sql-lover (12/3/2012)

    So pretty much, we only need the public network and the one for the private one...

    December 4, 2012 at 1:49 am

    #1565157

  • RE: instance port number

    sqlfriends (12/3/2012)

    Thanks,

    Can I use dynamic port for the named instance,

    When I install the named instance, and check the tcp\ip port, it defaults to blank, with dynamic port set to...

    December 3, 2012 at 11:54 pm

    #1565135

  • RE: instance port number

    Oops good catch Lynn I didn't spot that port number there

    December 3, 2012 at 11:47 pm

    #1565134

  • RE: instance port number

    sqlfriends (12/3/2012)

    I have a SQl SERVER that has a default instance and a named instance.

    Do I have to configure the named instance to use diffrent port than 1433 because the...

    December 3, 2012 at 4:32 pm

    #1565071

  • RE: 6 NICs for a Cluster?

    sql-lover (12/3/2012)

    My bad, we all know 3 is what we need ... 🙂

    No, not necessarily. It all depends on your network infrastructure and your redundancy requirements.

    sql-lover (12/3/2012)

    I am getting...

    December 3, 2012 at 4:29 pm

    #1565070

  • RE: Checking for Available Disk Space (outside of SQL Server)

    The wmi comsole is pretty good here. The problem with xp_fixeddrives is it cant return mounted volume details. Use something along the lines of

    wmic volume get capacity, "free space", name

    December 3, 2012 at 1:47 pm

    #1565035

    • Viewing 15 posts - 4,501 through 4,515 (of 9,253 total)