Forum Replies Created

Viewing 15 posts - 1,441 through 1,455 (of 9,244 total)

  • RE: What would be the process to Upgrade a SQL Server 2012 Ent. Act/Pass Failover Cluster to a SQL Server 2014 Ent. Failover Cluster

    Ed Wagner (1/29/2016)


    Perry Whittle (1/29/2016)


    Ed Wagner (1/29/2016)


    I was searching more for SQL Server

    Doubt you'll find that, upgrading the sql server version using rolling update is a supported path for...

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

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

  • RE: SQL Server Mount Points

    Theyre useful for standalone instances as well as clustered

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

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

  • RE: SQL Server Mount Points

    dajonx (1/29/2016)


    Yes, I do. I also read that eight data files should be the minimum if the server has more than eight cores (server will have 16 cores on...

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

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

  • RE: What would be the process to Upgrade a SQL Server 2012 Ent. Act/Pass Failover Cluster to a SQL Server 2014 Ent. Failover Cluster

    Ed Wagner (1/29/2016)


    I was searching more for SQL Server

    Doubt you'll find that, upgrading the sql server version using rolling update is a supported path for sql server

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

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

  • RE: Best practice dropping or disabling

    Just run

    exec sp_validatelogins

    This will identify any AD users or groups which have been removed from AD but not from the SQL Server instance

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

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

  • RE: Backup of Tail-Log

    Welsh Corgi (1/28/2016)


    I read some articles on backing up the tail log but I'm not clear on it.

    When do you use this option and when do you not?

    Typically used in...

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

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

  • RE: SQL Server Mount Points

    dajonx (1/29/2016)


    Thank you!

    I was wondering what you think about having two volumes for TempDB (data and log)

    You could split tempdb data and log, these must be kept separate fro user...

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

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

  • RE: SQL Server Mount Points

    dajonx (1/29/2016)


    Hi,

    What do you think about using mount points for SQL Server? Is there a performance difference between using a mount point or a drive letter?

    Any insight...

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

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

  • RE: How was this working? Availability Group Listener

    Connecting through SSMS?

    The listener connects you to the instance that's the Primary replica for the AO group, you'll see any databases you have access to.

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

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

  • RE: Password Recovery - Windows Server 2003/2008

    use NTPassword reset boot disk

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

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

  • RE: What would be the process to Upgrade a SQL Server 2012 Ent. Act/Pass Failover Cluster to a SQL Server 2014 Ent. Failover Cluster

    APA0876 (1/27/2016)


    Hi,

    This is my current scenario:

    Windows Server 2008 R2

    SQL Server 2012 Enterprise Edition Active \ Passive Failover Cluster

    Intended scenario:

    Windows Server 2012 R2

    ...

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

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

  • RE: CLustering Installation issues

    the solution would be to use a separate network for your iSCSI connections

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

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

  • RE: Where can we get SQL SERVER 2012 Cluster Installation step by step guide

    sram24_mca (1/29/2016)


    Is there any reference link or Website where we can get SQL SERVER 2012 Cluster Installation guide with trouble shooting techniques?

    Regards,

    Ram

    Everything you need is in my stairway on this...

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

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

  • RE: Restore TDE Database without the Private Key

    Welsh Corgi (1/28/2016)


    I thought that you need the Private Key to restore a TDE Database?

    All that I have is the following:

    tde.key

    tde.cert

    Master.Key

    Service Master.Key

    Is this enough to restore a TDE Database?

    I tried...

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

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

  • RE: ISCSI - CLustering

    what permission level does your account have?

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

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

Viewing 15 posts - 1,441 through 1,455 (of 9,244 total)