Forum Replies Created

Viewing 15 posts - 571 through 585 (of 9,244 total)

  • RE: SQL Server 2014 SP2 upgrade on Alwayson + FCI

    SQLPRODDBA - Tuesday, August 22, 2017 12:31 PM

    Thank you Perry for your reply! I didn't understand why AG failover is required since...

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

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

  • RE: Transaction Logs in Status 2 for no apparent reason

    Leo.Miller - Tuesday, August 22, 2017 6:15 PM

    but every time we add it back to test something the Sys Admin throws his...

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

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

  • RE: Transaction Logs in Status 2 for no apparent reason

    Leo.Miller - Sunday, August 20, 2017 7:52 PM

    1)      Regular Transaction log backups - every 30 minutes using CommVault

    30 mins may not be enough...

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

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

  • RE: Failed to create AppDomain "mssqlsystemresource.dbo[runtime].3". - SQL ERROR LOG

    this is usually components being unloaded due to memory pressure
    mem on the server and the max server mem would be a good place to start

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

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

  • RE: SQL Server 2014 SP2 upgrade on Alwayson + FCI

    SQLPRODDBA - Friday, August 18, 2017 3:10 AM

    I want to upgrade my SQL Server 2014 to SP2 which is involved...

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

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

  • RE: Error on Backup

    gary.mazzone - Friday, August 18, 2017 2:58 AM

    So everyone is saying that I need to bacip the cert. restore it to...

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

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

  • RE: How to enable SQL to connect with servername\instance with 2 node sql cluster?

    JP10 - Thursday, August 17, 2017 1:00 PM

    Hello,

    How can I make it available to connect to sql using servername\instance name with a...

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

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

  • RE: reboot server configured with AlwaysOn setup

    Zeal-DBA - Wednesday, August 16, 2017 6:02 AM

    hi 
    i have 3 node server with alwaysOn setup 1-primary 2 -secondary 3-secondary.
    wanted to reboot any...

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

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

  • RE: moving from standalone server to Cluster in EDW environment

    just multiple instances running.
    Having said that fewer databases per instance with instances running on separate nodes would guarantee a certain portion of performance unless both instances end up located...

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

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

  • RE: Can't open the master key on Always on SQL Server

    as its an availability group, you will need to backup the DMK in the primary SSISDB and restore to the secondfary SSISDB

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

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

  • RE: Can't open the master key on Always on SQL Server

    EasyBoy - Friday, August 11, 2017 7:50 AM

    Perry Whittle - Friday, August 11, 2017 2:36 AM

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

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

  • RE: Distributed Availability Group error message

    Beatrix Kiddo - Friday, August 11, 2017 2:33 AM

    That's what I thought, but he says that doesn't work...

    user error i would guess...

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

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

  • RE: Can't open the master key on Always on SQL Server

    EasyBoy - Thursday, August 10, 2017 9:33 AM

    We have fail-over cluster for one of our production environment.  It has two node with...

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

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

  • RE: Standard to Enterprise Edition upgrade or reinstall

    the edition upgrade is no problem, it just updates the sql server edition.
    The dlls required are already on disk, theyre not activated until the edition is updated.

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

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

Viewing 15 posts - 571 through 585 (of 9,244 total)