Forum Replies Created

Viewing 15 posts - 691 through 705 (of 9,244 total)

  • RE: Automate Encryption Key opening in HA environment

    can you detail a little more about your ha environment please

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

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

    June 20, 2017 at 5:26 am

    #1947360

  • RE: Problems when install instance features

    try a counter rebuild from the command prompt then reboo the server

    lodctr /r

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

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

    June 20, 2017 at 5:08 am

    #1947359

  • RE: Reseeding indexes for tables with data

    Chris Harshman - Monday, June 19, 2017 12:31 PM

    Perry Whittle - Monday, June 19, 2017 11:27 AM

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

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

    June 20, 2017 at 4:55 am

    #1947357

  • RE: Reseeding indexes for tables with data

    tarr94 - Monday, June 19, 2017 10:34 AM

    Hello,

    I have a database with many tables containing auto-incrementing Pk's.  Somehow, things got messed up...

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

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

    June 19, 2017 at 11:27 am

    #1947293

  • RE: Move tempdb file across Cluster enviroment

    carolmartinesgarcia - Wednesday, June 14, 2017 2:21 PM

    Thanks! I will do this. For prevent the FailOver (The company dont´t want it) ,...

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

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

    June 15, 2017 at 5:02 am

    #1946910

  • RE: What can be serious consequence of using Local System Account or Built Account for SQL Server Service?

    John Mitchell-245523 - Thursday, June 15, 2017 4:33 AM

    using Local System means you don't have access to resources on different servers, for...

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

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

    June 15, 2017 at 4:44 am

    #1946909

  • RE: Drop Service Master Key or Change Password?

    gdpollock - Wednesday, June 14, 2017 8:29 AM

    By the way, I just finished your article about SMKs, DMKs, and Certificates....

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

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

    June 14, 2017 at 8:55 am

    #1946787

  • RE: AlwaysOn - adding secondary problem

    ifilter - Wednesday, June 14, 2017 8:04 AM

    I found the problem that was restricting me from adding a secondary replica.  First to...

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

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

    June 14, 2017 at 8:24 am

    #1946778

  • RE: Drop Service Master Key or Change Password?

    gdpollock - Wednesday, June 14, 2017 8:14 AM

    don't drop the SMK.

    You can't drop it!
    You can back it up, restore it and alter...

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

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

    June 14, 2017 at 8:22 am

    #1946775

  • RE: Drop Service Master Key or Change Password?

    gdpollock - Wednesday, June 14, 2017 7:45 AM

    At first, I ran the below command to create the certificate, and I just...

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

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

    June 14, 2017 at 7:58 am

    #1946762

  • RE: Drop Service Master Key or Change Password?

    What was the exact error you received

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

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

    June 14, 2017 at 7:32 am

    #1946755

  • RE: Drop Service Master Key or Change Password?

    gdpollock - Wednesday, June 14, 2017 6:05 AM

    Thank you for your feedback.  Yes, I am planning on implementing TDE.
    What I'm hearing is...

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

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

    June 14, 2017 at 6:50 am

    #1946738

  • RE: Drop Service Master Key or Change Password?

    gdpollock - Tuesday, June 13, 2017 2:46 PM

    Hi All,

    I'm rusty with admin and definitely new to master keys.  I'm working on a...

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

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

    June 14, 2017 at 5:58 am

    #1946721

  • RE: Daily FULL backups?

    TheSQL_fan - Tuesday, June 13, 2017 6:38 AM

    Perry Whittle - Tuesday, June 13, 2017 4:38 AM

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

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

    June 13, 2017 at 9:27 am

    #1946576

  • RE: AlwaysOn - adding secondary problem

    ifilter - Tuesday, June 13, 2017 7:55 AM

    Perry Whittle- Under Windows Failover Cluster Manager it shows that both physical servers are nodes...

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

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

    June 13, 2017 at 8:48 am

    #1946562

Viewing 15 posts - 691 through 705 (of 9,244 total)