Forum Replies Created

Viewing 15 posts - 3,976 through 3,990 (of 9,244 total)

  • RE: Multi node multi instance clustering Drive letters

    for more info on mountpoints see here[/url]

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

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

  • RE: always on Option in mirroring

    these may help

    alwayson[/url]

    alwayson with clustered instances[/url]

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

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

  • RE: SQL Server layout on a SAN

    BobMcC (8/20/2013)


    So it looks like you're saying I'm still making things too complex.

    Rather than have one file group with files on six LUNS; perhaps have multiple file groups;...

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

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

  • RE: SQL Server layout on a SAN

    BobMcC (8/20/2013)


    Thanks Perry.

    So in the case of my six luns; I guess the best thing to do is create one FileGroup with a data files on each LUN (of the...

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

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

  • RE: Setting up server to add a node to a cluster.

    introduce the new node to the cluster and present the storage, then run add node on the new cluster node. Ensure that any validation checks complete successfully before adding the...

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

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

  • RE: SQL Server layout on a SAN

    BobMcC (8/19/2013)


    I've read (in the NetApp documentation) that the Microsoft recommendation on multiprocessor servers is to have at least one LUN per logical processor.

    Hmmmm, no, that's only really valid for...

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

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

  • RE: Creating A SQL Server 2008\2008 R2 Failover Cluster

    anybody wanting the guide please download from this link

    Creating a 2 node SQL Server 2008 Cluster Configuration

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

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

  • RE: SAN Migration - DataFiles movement to new drives

    ArjunaReddy (8/18/2013)


    Hi,

    We have got new space (SAN) allocated recently by storage folks to one of our database server to resolve I/O issues with some specific drives (D: & E:). Inorder...

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

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

  • RE: Manually failover database mirroring

    ananda.murugesan (8/14/2013)


    I have doubt.. I have Mirror setup manual failover without witness server

    If Principal server is down due to N/W or H/W issues, In this cause mirror database condition is...

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

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

  • RE: Can we assign port 1433 to a named instance

    you can assign any unused port you want but default is 1433.

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

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

  • RE: I/O requests taking longer than 15 seconds to complete

    can you provide more detail about your I\O subsystem?

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

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

  • RE: Manually failover database mirroring

    david.alcock (8/12/2013)


    Can I do this on the mirror?

    ALTER DATABASE<Databasename> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS

    Losing the principal in either async mode or sync mode with no witness requires you to use the above...

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

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

  • RE: Space on Server

    This thread is 5yrs old! 😉

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

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

  • RE: cluster setup

    My guide at the following links cover a 2 node cluster, but its still relevant for a 3node cluster

    Part1[/url]

    Part2[/url]

    Part3[/url]

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

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

  • RE: Clustering Question

    Sapen (8/5/2013)


    Hello All,

    I have a question on SQL Server 2008 R2 Std Edition clustering. I am trying to setup clustering for our SQL Server staging environment. We have a lot...

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

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

Viewing 15 posts - 3,976 through 3,990 (of 9,244 total)