Forum Replies Created

Viewing 15 posts - 976 through 990 (of 9,244 total)

  • RE: Failover Cluster - Better option

    dbaduck

    It gives you multiple failover targets and no single point of failure on a 1:1 scenario.

    FCIs do have a SPF, the shared storage!

    dbaduck

    I would put them all...

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

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

    February 9, 2017 at 10:34 am

    #1927596

  • RE: Unplanned failover of AG

    SQLAssAS - Thursday, February 9, 2017 10:02 AM

    Last night our AG failed over to our passive node (same subnet). This isn't a...

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

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

    February 9, 2017 at 10:17 am

    #1927587

  • RE: Connection Strings. Why?

    mountcrumpit - Wednesday, February 8, 2017 8:50 PM

    Hi everyone,   I imagine quite a few folks groan when they hear: SQL Connection String. ...

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

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

    February 9, 2017 at 10:12 am

    #1927583

  • RE: Unplanned failover of AG

    under what accounts do the sql server services run on each node?

    does the listener name and ip come online at all on the second node, check the cluster...

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

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

    February 9, 2017 at 10:05 am

    #1927580

  • RE: All disk space used, after deleting rows the table has 6GB "unused"space but I cannot release it or shrink the mdf.

    rebuild the indexes on the events table and then check the free space in the mdf

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

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

    February 9, 2017 at 10:03 am

    #1927578

  • RE: Failover Cluster - Better option

    be careful with this, having a large number of cluster nodes with FCIs installed across all noeds will affect the installer and patch runtime.
    On large clusters with lots of...

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

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

    February 9, 2017 at 9:55 am

    #1927574

  • RE: Hardening SQL Server

    Eric M Russell - Thursday, February 9, 2017 7:41 AM

    Look into implementing TDE (transparent database encryption). It will automagicly keep your data...

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

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

    February 9, 2017 at 9:51 am

    #1927572

  • RE: All disk space used, after deleting rows the table has 6GB "unused"space but I cannot release it or shrink the mdf.

    syen.j - Thursday, February 9, 2017 2:45 AM

    Dear,

    We have a table with 100 million rows and 1 clustered index (primary key).
    The hard...

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

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

    February 9, 2017 at 7:22 am

    #1927524

  • RE: Hardening SQL Server

    server hardening starts with the basics

    • dont leave the server sitting under someone's desk in an open plan office

    • dont grant local admin to the world and his...

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

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

    February 9, 2017 at 7:17 am

    #1927522

  • RE: TDE after restoring to a Different Instance

    VastSQLThanks Perry,

    DMK is only for the master database right,correct me if I am wrong.

    Wrong, that's why it's important to create a DMK in the master database...

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

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

    February 9, 2017 at 5:25 am

    #1927489

  • RE: SQL SERVER FCI vs AG's

    Luke L Are you saying that the FCI fail over will be manual or only the fail over from the FCI to one of the secondary AG's?

    No, it's not...

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

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

    February 9, 2017 at 5:11 am

    #1927486

  • RE: SSRS, can we put multiple set of Reportserver databases on a single server

    you can absolutely have multiple Reportserver databases on a single instance, that's why you get the option to supply a unique name for the Reportserver database instead of just accepting...

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

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

    February 8, 2017 at 9:27 am

    #1927366

  • RE: AlwaysOn Clarification

    butcherking13 - Wednesday, February 8, 2017 7:00 AM

    I have to add disk space to a secondary and hoping for clarification. I know...

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

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

    February 8, 2017 at 8:29 am

    #1927349

  • RE: SQL SERVER FCI vs AG's

    Luke L - Wednesday, February 8, 2017 7:08 AM

    We currently have a...

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

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

    February 8, 2017 at 8:26 am

    #1927347

  • RE: TDE after restoring to a Different Instance

    So, why are you trying to use the following, what are you hoping it to do, given there is no database master key in the database [Encrypt_DiffCert]

    VastSQL

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

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

    February 8, 2017 at 6:23 am

    #1927301

    • Viewing 15 posts - 976 through 990 (of 9,244 total)