Forum Replies Created

Viewing 15 posts - 2,431 through 2,445 (of 9,241 total)

  • RE: Database File Placement and number of files

    HookSqlDba7 (2/2/2015)


    1 TB Log File.

    Wow

    HookSqlDba7 (2/2/2015)


    I am looking at the possible layout of the database files and trying to determine the best possible configuration. My knowledge/research tells me that...

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

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

  • RE: Service Pack Cluster with SQL offline

    j.snowden (1/30/2015)


    Hi, I'm applying a service pack to 2008r2 cluster 2 node cluster with mirroring to another 2 node cluster in DR, i was planning to perform a rolling patch.....

    My...

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

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

  • RE: Transaction Log Shrink with Availability Group set up

    would help if you posted it in the correct forum location 😉

    What version\edition of SQL Server are you using?

    How many databases are in the availability group?

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

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

  • RE: Is it possible to make two existing standalone instances trunning in seperate nodes clustered

    you cannot convert a standalone instance into a clustered instance, you will need to form a cluster on the 2 nodes and install new clustered instances and then migrate any...

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

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

  • RE: SQL 2012 on VMWare with HA - clustering?

    RamoneThePoolGuy (1/31/2015)


    So my main question is: given that we are in a VMWare HA environment, is clustering necessary?

    A windows cluster on VMware has restrictions, you can't easily migrate the cluster...

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

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

  • RE: Rename a Live database

    is this database in an Availability group?

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

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

  • RE: important : About HA : in Which event , Automatic Repoint happens?

    Are you saying your filling the database in an attempt to failover the AO group??

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

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

  • RE: Difference between Truncateonly and NoTruncate

    seems to be different between 2008R2 documention and 2012 documentation,

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

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

  • RE: Re-establish mirroring after DR test

    no, your original post which i read said you broke the mirror session in this scenario a differential may be used to bridge any LSN gap, seems i had mis...

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

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

  • RE: SQL 2012 failover cluster ideas - AlwaysON

    if you're replicating between 2 nodes they both cant be primary. One will be primary one will be secondary, it seems you are after either database mirroring or AlwaysOn Availability...

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

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

  • RE: Edition Upgrade from MS SQL 2012 C0 to MS SQL 2012 Enterprise

    Br. Kenneth Igiri (1/29/2015)


    I have attempted an Edition upgrade from MS SQL Server 2012 C0 to MS SQL Server Enteprise on two occassions and in both cases I find that...

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

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

  • RE: Advice for cross-site clustering

    you're welcome

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

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

  • RE: Migration of AlwaysON database 2012 to 2014

    Fernando Jacinto Alvarez (1/29/2015)


    My boss want to migrate to sql 2014 currently we have another site and he wants to create a DR using AlwaysOn AG what do you suggest...

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

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

  • RE: SQL 2012 failover cluster ideas - AlwaysON

    level 7 is not published yet but you can find detail on combining an FCI into an AlwaysOn group starting at this link[/url]

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

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

  • RE: Advice for cross-site clustering

    check out my stairway series on this site for more info. Level 6 is due to be published soon and covers AlwaysOn Availability groups and readonly routing in detail.

    Part 1...

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

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

Viewing 15 posts - 2,431 through 2,445 (of 9,241 total)