Forum Replies Created

Viewing 15 posts - 2,356 through 2,370 (of 9,244 total)

  • RE: Another Interesting Always On Question

    If you absolutely have to do something meantime, implement a basic LS plan in the interim until your AO config goes live and then remove the LS plan once AO...

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

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

  • RE: Another Interesting Always On Question

    not there already but imminent i think.

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

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

  • RE: Another Interesting Always On Question

    Ozzmodiar (2/16/2015)


    It's been a long while since I've used log shipping to be honest; I wasn't aware that it was a 2-way process.

    It isnt as such. You can role reverse...

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

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

  • RE: Shut Down Cluster

    AndrewSQLDBA (2/16/2015)


    I am preparing to format the MountPoints on a SQL 2008 Cluster. Currently there are in use databases, logs and index files on these MountPoints. I want to shut...

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

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

  • RE: Another Interesting Always On Question

    Ozzmodiar (2/16/2015)


    Hello again SQL Server Central Community,

    First off, a big thanks to Perry Whittle for his help a while back with my HA architecture questions; it really helped me to...

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

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

  • RE: AlwaysOn Listener on Multi subnet AG

    start by reading this

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

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

  • RE: cluster 2012 vs 2008R2

    it's pretty much similar, the installation wizard is not to different.

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

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

  • RE: cluster 2012 vs 2008R2

    for what's new in SQL Server 2012 review starting at this link

    For the node OS, prefer Windows 2012 R2 over Windows 2008 R2. There are numerous enhancements to the OS...

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

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

  • RE: Is it possible to rename MSSQL Instance Name

    aprathour.89 (2/14/2015)


    Hi everyone,

    I have two sql instances installed in two node failover cluster mode, i want to rename one of my sql instance, is it possible to change instance name...

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

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

  • RE: Data movement on TDE enabled database!!!

    correct, TDE only protects the actual data files themselves at rest (and any backups created on them).

    You will need to encrypt the communication channel between the endpoints, this can be...

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

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

  • RE: SQL Server 2012 AlwaysOn latency on a synchronous secondary after a committed transaction

    Typically you will see a minute lag, much as you are now, you'll always have to allow for how busy the secondary may be.

    Also, as the redo queue grows...

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

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

  • RE: Restore an ecnrypted sql server 2014 backup via GUI

    no problem, you're welcome

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

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

  • RE: master.dbo.xp_delete older backup files not deleted

    SQL Galaxy (2/13/2015)


    after adding account in backup folder and given modify privileges.

    😉

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

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

  • RE: why does pausing mirroring improve performance?

    sorry I'm confused, pausing the mirror session improves performance yet you say they both take 10 mins???

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

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

  • RE: SQL Server 2012 AlwaysOn latency on a synchronous secondary after a committed transaction

    Mike G. (2/12/2015)


    Is this latency expected behavior?

    Synchronous commit only guarantees the transaction is fully committed to the log on all partners, the log record will still have to...

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

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

Viewing 15 posts - 2,356 through 2,370 (of 9,244 total)