Forum Replies Created

Viewing 15 posts - 2,491 through 2,505 (of 9,241 total)

  • RE: Partitioning: Maximum of 1000 partitions reached

    also read the doc at the following link

    https://msdn.microsoft.com/en-us/library/gg981694.aspx

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

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

  • RE: Partitioning: Maximum of 1000 partitions reached

    there is a patch to enable 15000 partitions what is your exact sql server edition\version?

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

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

  • RE: SQL 2012 failover cluster ideas - AlwaysON

    johnnyrmtl (1/25/2015)


    K great... Although I do have to install this FCI tomorrow and wanted to understand it as much as possible by then as to not start it over.

    Any draft...

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

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

  • RE: SQL 2012 failover cluster ideas - AlwaysON

    yes level 5 is to be published on 11th feb

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

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

  • RE: SQL 2012 failover cluster ideas - AlwaysON

    Levels 1 to 4 detail the requirements for a windows server failover cluster, this forms the basis of either an FCI or an AlwaysOn Availability group setup.

    Level 5 details FCIs...

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

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

  • RE: SQL 2012 failover cluster ideas - AlwaysON

    johnnyrmtl (1/24/2015)


    I am somewhat confused as the guide for an " AlwaysOn Failover Cluster Instance" mentions the creation of "Availability groups".

    If my application is constantly creating new databases, do I...

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

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

  • RE: Netbackup Restore - Encrypted Database

    the cert should only require creating once, is this a backup of the same database or another?

    Has the cert changed on the source server maybe and now doesn't match the...

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

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

  • RE: SQL SERVER + SSD

    chucking in SSDs will just probably mask the real issue. SSDs are indeed faster than traditional disks but even they have a limit.

    It's been said already, code and database design...

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

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

  • RE: SQL 2012 failover cluster ideas - AlwaysON

    see my stairway series on this site starting at this link[/url]

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

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

  • RE: SQL 2012 failover cluster ideas - AlwaysON

    johnnyrmtl (1/21/2015)


    That is indeed my dilemma as new databases will be added continuously to the instance 🙁

    What would be the best solution ?

    What is it you're looking to achieve, high...

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

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

  • RE: physical nodes and VMs -windows cluster

    check everything, the networking between the nodes, the networking between the domain controller and the node, also the permission level of the user running the add node operation

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

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

  • RE: physical nodes and VMs -windows cluster

    check the windows event log and the cluster events too

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

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

  • RE: SQL 2012 failover cluster ideas - AlwaysON

    johnnyrmtl (1/21/2015)


    Thanks for the reply...and sorry for the confusion.

    I need to propose a 2 server clustering / failover solution with SQL 2012 and it seems that the log shipping feature...

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

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

  • RE: physical nodes and VMs -windows cluster

    if you're getting a timeout sounds like either a firewall or issue in the networking stack. Is the cluster validation report completely clean?

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

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

  • RE: Atuomating SQL Server 2008 R2 cluster installation

    virgo (1/16/2015)


    Hi...

    Can any one help me with steps and methods for automating the sql server cluster installation with out using the GUI. Can we have a config file or scripts...

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

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

Viewing 15 posts - 2,491 through 2,505 (of 9,241 total)