Forum Replies Created

Viewing 15 posts - 1,591 through 1,605 (of 9,244 total)

  • RE: Required Permissions to Enable A Mirroring Session

    so nothing to do with permissions then

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

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

  • RE: AlwaysOn for HA/DR

    Barcelona10 (11/5/2015)


    Hi All,

    We are trying to find best HA/DR solution for our (SQL Sever 2008R2 STD )PRD server.We were thinking to go with Database Mirroring or Failover Clustering.But since Mirroring...

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

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

  • RE: Downgrade SQL Server / Install Master Database

    tress (11/4/2015)


    Hi,

    Hoping someone can help with this, I am currently having to downgrade my SQL Server in my test environment from Enterprise Edition to Standard Edition. I backed up...

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

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

  • RE: SQL 2014 SP1 Active Passive Cluster

    744 (11/4/2015)


    Hi,

    We have a SQL 2014 active passive cluster with 5 instances. When the cluster was installed one of the nodes was a virtual machine. As we started to have...

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

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

  • RE: Max Server Memory

    krypto69 (11/4/2015)


    Hi,

    Just inherited a new VMWare SQL2014 server.

    I noticed the max server memory is set to 2147483647 MB. Which I realize now is the default.

    I know from the sysadmin...

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

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

  • RE: AlwaysOn Certificate Problem

    more detail please

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

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

  • RE: "Transfer Logins Task"

    Arestas (11/3/2015)


    Hello all,

    As we all know logins and jobs aren't replicated when using AllwaysOn. What i wanna know is if the "tranfer login taks" will be enough to cover the...

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

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

  • RE: Primary file and secondary files

    or they just read somewhere that it's a best practice

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

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

  • RE: Using Symmetric Key encryption

    you're welcome

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

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

  • RE: Using Symmetric Key encryption

    Are you merely attempting to enable TDE?

    jayoub (11/2/2015)


    A: Run the following to create a certificate:

    USE <'database name'>

    CREATE CERTIFICATE <'certificate name'>

    ENCRYPTION BY PASSWORD = '<'password'>'

    FROM...

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

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

  • RE: Add Node

    m_obegi87 (10/9/2015)


    Dear all,

    i am trying to add a node to the cluster failover, and i am running it through the command line,

    everything seems fine in the summary and detail logs...

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

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

  • RE: Compressed backup to Compressed Restore

    sraghunandana.6 (11/2/2015)


    So now i should ask our Infra team to add some extra space before i restore

    That would be a really good idea 😉

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

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

  • RE: Restore Conflict (restore)

    JakDBA (11/1/2015)


    Yes thats rite,similar Logical names are not allowed. But its possible to restore the full backup of same logical name backup copy with different logical name.

    follow the link

    https://technet.microsoft.com/en-us/library/ms190447(v=sql.105).aspx...

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

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

  • RE: Slow backup on HA secondary

    which hypervisor are you using?

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

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

  • RE: AlwaysOn failover cluster session failover

    udara0306 (10/31/2015)


    Hi,

    My always on cluster 2 replica with sync mode and DR one with Async mode.

    regards

    ud

    If you have 2 replicas configured for synch mode and auto failover the transition will...

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

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

Viewing 15 posts - 1,591 through 1,605 (of 9,244 total)