Forum Replies Created

Viewing 15 posts - 586 through 600 (of 9,244 total)

  • RE: encryption key - always on failover

    juniorDBA13 - Wednesday, August 9, 2017 8:22 AM

    Yes it is

    you only need to restore the cert backup to the secondary server.
    SMK on...

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

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

    August 9, 2017 at 9:12 am

    #1954658

  • RE: encryption key - always on failover

    juniorDBA13 - Wednesday, August 9, 2017 7:52 AM

    The databases is encrypted on the primary so when you restore to the secondary it...

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

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

    August 9, 2017 at 8:19 am

    #1954637

  • RE: encryption key - always on failover

    okay, golden rule, do not restore DMKs across instances, there is no need to and it's an extra security risk.

    Now for the default behaviour with DMks.

    • If...

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

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

    August 9, 2017 at 7:20 am

    #1954622

  • RE: encryption key - always on failover

    and no DMK existed on the instance before the key was restored from the primary server?

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

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

    August 9, 2017 at 5:54 am

    #1954592

  • RE: encryption key - always on failover

    was this DMK restored from the primary server?

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

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

    August 9, 2017 at 5:36 am

    #1954586

  • RE: Reducing max server memory in sql server

    be aware that the max server memory in 2012 onwards encompasses a lot more than the buffer pool and proc cache.
    How much memory does the server have?
    is sql...

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

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

    August 9, 2017 at 5:30 am

    #1954584

  • RE: AG across different SQL versions?

    SQL_Hacker - Monday, August 7, 2017 6:18 PM

    The problem could crop up if/when either the 2014/2016 instance becomes primary, and for whatever...

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

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

    August 9, 2017 at 5:27 am

    #1954583

  • RE: Best way to encrypt credit card information?

    GilaMonster - Thursday, August 3, 2017 7:10 AM

    He doesn't want to change it, doesn't want a new column, but wants the...

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

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

    August 3, 2017 at 7:55 am

    #1953971

  • RE: Best way to encrypt credit card information?

    theyre probably unhappy with an excel spreadsheet doing the rounds with unencrypted card numbers.

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

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

    August 3, 2017 at 5:47 am

    #1953925

  • RE: SQL Server AlwaysOn among two data centers with auto failover

    dcw8888 - Wednesday, August 2, 2017 11:34 AM

    2 Nodes and a witness share solution
    If I put Primary Node and a witness share...

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

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

    August 3, 2017 at 4:46 am

    #1953912

  • RE: Change Service account password for multiple servers using T-SQL query or WMI Script or PowerShell script or SSIS script

    powershell probably the best route, clustered or non clustered instances?

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

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

    August 2, 2017 at 10:17 am

    #1953813

  • RE: Drive Letter Issue

    narayanamoorthy.a - Wednesday, August 2, 2017 8:38 AM

    Hi,

    The database data(MDF) and log(LDF) files are mapped to L:\ drive and the database is...

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

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

    August 2, 2017 at 10:14 am

    #1953811

  • RE: SQL Server geo-cluster 2016

    i really wouldnt throw listeners or anything esle out there at the moment until the OP has had chance to digest all the info that's been presented

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

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

    August 2, 2017 at 9:54 am

    #1953809

  • RE: Bidirectional Failover on SQL Server Standard Edition

    Phil Parkin - Tuesday, August 1, 2017 11:36 AM

    Hi all, in what follows, please bear in mind that I'm just a humble...

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

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

    August 2, 2017 at 9:52 am

    #1953807

  • RE: Bidirectional Failover on SQL Server Standard Edition

    bmg002 - Tuesday, August 1, 2017 3:27 PM

    And I believe it is a lot cheaper than a windows enterprise license, which if...

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

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

    August 2, 2017 at 9:51 am

    #1953805

    • Viewing 15 posts - 586 through 600 (of 9,244 total)