Forum Replies Created

Viewing 15 posts - 886 through 900 (of 9,244 total)

  • RE: SQL Cluster on VMs in cross DCs

    all potential node members of the cluster must be a part of the same windows domain

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

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

  • RE: 1 windows failover cluster and 4 Availability groups, is it possible?

    ThomasRushton - Wednesday, March 8, 2017 4:04 AM

    Yup, it's possible.  I've worked in the past with a server setup as you describe...

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

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

  • RE: Can I just attach to a database?

    just to clarify, it's not a case of whether the instance was shutdown cleanly, but whether the database itself was shut down cleanly.
    A clean system shutdown is a good...

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

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

  • RE: SQL Server encryption question

    Satya Krishna - Wednesday, March 8, 2017 8:43 PM

    I have a requirement from a client that requires all SQL connections be...

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

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

  • RE: File Share Witness in Multiple Clusters

    alex.sqldba - Thursday, March 9, 2017 7:25 AM

    Morning All,

    Can a single File Share Witness (about 10GB in size) be used to provide...

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

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

  • RE: AlwaysOn vs Replication vs Mirroring

    replication is carried out at the individual object level within a database, it's nothing like mirroring or availability groups.

    AlwaysOn availability groups are essentially an extension of database mirroring....

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

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

  • RE: SQL Server 2012 AlwaysOn Configuration

    multi subnet clustering is supported on sql server 2012

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

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

  • RE: SQL Server 2014 Patching (on Cumulatives updates) and Rolling Updates - Need advice

    szejiekoh - Saturday, March 4, 2017 11:02 AM

    Just some last confirmation on patching and upgrading ->
    q1) when we patched the secondary...

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

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

  • RE: 1 windows failover cluster and 4 Availability groups, is it possible?

    Siten0308 - Tuesday, March 7, 2017 7:51 AM

    Thanks SSCommitted, one last thing to ask... has anyone ever installed multiple instances on 1...

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

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

  • RE: Windows Authenticaion vs. Mixed Mode

    bmg002 - Wednesday, March 1, 2017 10:21 AM

    what would you do if some software update mucked around with the firewall settings...

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

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

  • RE: SQL Server on VMWare w/1CPU 1 Core

    if an application to be installed within the virtual server uses SMp then at least 2 vcpu shares should be granted.
    SQL Server is an SMP application

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

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

  • RE: Auto failover on alwasyon asynchronous

    mssqlchat - Friday, March 3, 2017 2:16 AM

    Currently we are using SQL Server 2014 Enterprise version. Due to OLTP database we...

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

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

  • RE: Shrink log file

    ALZDBA - Friday, March 3, 2017 12:52 AM

    This is the sequence I use:

    -- 0 = db file info
    -- 1 = backup...

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

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

  • RE: Clustering with logshipping setup..need advice

    no, especially if the luns have the system databases on from the clustered instance.
    Do not move system databases between instances, especially clustered instances.
    Failing over to a LS secondary...

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

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

  • RE: Change sql server collation

    JasonClark - Wednesday, March 1, 2017 10:33 PM

    WhiteLotus - Tuesday, February 28, 2017 6:12 PM

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

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

Viewing 15 posts - 886 through 900 (of 9,244 total)