Forum Replies Created

Viewing 15 posts - 721 through 735 (of 9,244 total)

  • RE: Stopping Service in Cluster

    Rechana Rajan - Thursday, June 8, 2017 5:32 AM

    Perry Whittle - Thursday, June 8, 2017 3:24 AM

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

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

  • RE: SAN Drives question. Format 4k or 64k blocks

    bmg002 - Wednesday, June 7, 2017 2:19 PM

    recommended is 64k due to that being the size of an extent.

    An extent is 1...

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

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

  • RE: Stopping Service in Cluster

    Rechana Rajan - Thursday, June 8, 2017 2:43 AM

    Perry Whittle - Wednesday, June 7, 2017 10:03 AM

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

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

  • RE: Stopping Service in Cluster

    Rechana Rajan - Wednesday, June 7, 2017 8:12 AM

    Thanks perry

    Perry Whittle - Wednesday, June 7, 2017 4:05 AM

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

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

  • RE: Log Shipping backup file name

    89netanel - Wednesday, June 7, 2017 8:08 AM

    Can the file name contain also milliseconds?

    Just interested to know what you think this can...

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

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

  • RE: Database in recovery pending state

    have you tried removing the secondary database from the availability group and re initialse it

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

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

  • RE: Converting User SID Binary to String TSQL

    sorry, yes typo, it's a function.
    The AD SID will be a completely different format to the SID that the SQL Server instance generates.
    The AD SID applies a specific...

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

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

  • RE: Stopping Service in Cluster

    Rechana Rajan - Wednesday, June 7, 2017 3:45 AM

    Perry Whittle - Thursday, May 11, 2017 7:13 AM

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

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

  • RE: trans log file growth

    Snargables - Monday, June 5, 2017 12:19 PM

    I'm using Microsoft SQL Server 2014 (SP2) (KB3171021) - 12.0.5000.0 (X64)
     Jun 17 2016 19:14:09...

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

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

  • RE: How Does Preferred Owner Effect Availability Groups

    ok, it's an enhancement in 2016.
    You may want to read this

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

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

  • RE: How Does Preferred Owner Effect Availability Groups

    alex.sqldba - Monday, June 5, 2017 7:54 AM

    Okay.

    How does one change the order in which fail over occurs.

    If I have 4...

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

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

  • RE: How Does Preferred Owner Effect Availability Groups

    alex.sqldba - Monday, June 5, 2017 6:49 AM

    Cheers for that.

    Just to confirm, I can change the order they are in the list...

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

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

  • RE: How Does Preferred Owner Effect Availability Groups

    alex.sqldba - Monday, June 5, 2017 5:01 AM

    Well, I was referring to this screen:

    But looking at the...

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

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

  • RE: Converting User SID Binary to String TSQL

    SQL Dude-467553 - Monday, March 8, 2010 12:49 PM

    Hello All,Basically I'm trying to use TSQL to convert user SIDS from Binary to...

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

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

  • RE: Cluster Virtual Adaptor Error status 0x80080490

    gods-of-war - Wednesday, May 31, 2017 12:09 PM

    W2k12/SQL-2012 11.0.5058
    Failover Cluster, 2 nodes.
    Worked for a year and a half, then we had a...

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

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

Viewing 15 posts - 721 through 735 (of 9,244 total)