Forum Replies Created

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

  • 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" 😉

  • RE: SQL 2012 Always ON

    p.swathi4 (2/12/2015)


    I am trying to configure SQL Always ON.I am getting an SQL server error 19471. I am having issue in creating Listener but rest all steps are succesful.And when...

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

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

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

    Hmm, I thought so. This is not exactly a bug, although BOL should explain a little better what happens when you restore a DMK :angry:

    When you restore the DMK from...

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

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

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

    Igor Micev (2/10/2015)


    I have restored the master key from the instance where the encrypted backup was created on the instance where I want to restore the encrypted backup

    Just out of...

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

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

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