Forum Replies Created

Viewing 15 posts - 316 through 330 (of 9,244 total)

  • RE: Read-Only Routing

    coolchaitu - Wednesday, April 11, 2018 11:10 AM

    Good Morning Experts,

    We have configured read-only routing in Availability Groups , SQL Server 2014....

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

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

    April 11, 2018 at 1:31 pm

    #1986464

  • RE: Index rebuilt/Reorganize script didn't remove fragmentation

    Scott Coleman - Thursday, April 5, 2018 11:57 AM

    If index_id = 0, it is a heap and cannot be rebuilt (except by...

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

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

    April 11, 2018 at 1:25 pm

    #1986461

  • RE: Installing SQL Server 2008R2 Ent Edit On VMWare Q

    YSLGuru - Monday, April 9, 2018 9:53 AM

    We are in the process of implementing a new SANS that will host all of our...

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

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

    April 11, 2018 at 1:14 pm

    #1986457

  • RE: Client and Server cannot communicate...they do not posses a common algorithm

    EMtwo - Wednesday, April 11, 2018 11:08 AM

    Microsoft SQL Server 2008 R2 (SP1) - 10.50.2550.0 (X64)
        Jun 11 2012 16:41:53
        Copyright (c) Microsoft...

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

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

    April 11, 2018 at 1:06 pm

    #1986455

  • RE: SQL Server Agent stops running after changing the default listening port

    hurricaneDBA - Wednesday, April 11, 2018 12:49 PM

    So what would be your recommended approach?By the way I kept shared memory enabled because I...

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

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

    April 11, 2018 at 1:02 pm

    #1986454

  • RE: Upgrading to Service Pack 2 with Always On H/A

    krypto69 - Wednesday, April 11, 2018 9:54 AM

    HI,

    I need to update three SQL2014 SP1 servers to SP2. The three servers are in...

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

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

    April 11, 2018 at 10:00 am

    #1986392

  • RE: Client and Server cannot communicate...they do not posses a common algorithm

    EMtwo - Wednesday, April 11, 2018 9:22 AM

    Hello:
    So, enabling the TLS 1.0 in the registry on the SQL Server 2014 Server solved...

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

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

    April 11, 2018 at 9:58 am

    #1986391

  • RE: Client and Server cannot communicate...they do not posses a common algorithm

    EMtwo - Tuesday, April 10, 2018 7:55 AM

    Microsoft SQL Server 2014  64-bit  Standard Edition and  Microsoft SQL Server 2008 R2 SP1 64-bit Enterprise...

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

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

    April 11, 2018 at 9:57 am

    #1986390

  • RE: Log Shipping troubleshooting questions

    gloeffler - Tuesday, April 10, 2018 2:42 PM

    Hello, First time posting here.  I have a few unanswered questions about troubleshooting log shipping...

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

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

    April 11, 2018 at 9:21 am

    #1986379

  • RE: Change DB to Restoring state

    Alexander Zhang - Tuesday, April 10, 2018 4:21 PM

    Now, the DB is in SIMPLE recovery mode without any backup. The traditional way...

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

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

    April 11, 2018 at 9:18 am

    #1986378

  • RE: SQL Server Agent stops running after changing the default listening port

    Sue_H - Wednesday, April 11, 2018 8:19 AM

    hurricaneDBA - Wednesday, April 11, 2018 7:55 AM

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

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

    April 11, 2018 at 9:08 am

    #1986374

  • RE: SQL Server Agent stops running after changing the default listening port

    Is this a named instance or default instance?

    What port number are you changing from and to?

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

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

    April 10, 2018 at 11:26 pm

    #1986258

  • RE: Migration from SQL 2008 to 2017

    Never assume, that’s the worst thing to do.

    Go back to the client and request your account has at least server role dbcreator.

    Don’t need to zip the files just copy them...

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

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

    April 10, 2018 at 11:21 pm

    #1986256

  • RE: Client and Server cannot communicate...they do not posses a common algorithm

    EMtwo - Monday, April 9, 2018 4:51 PM

    Yes. TLS 1.0 is disabled for both client and server.

    What `are the exact versions of the...

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

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

    April 10, 2018 at 3:31 am

    #1986077

  • RE: Reporting/HA design advice- FCI with AG

    Yuri55 - Monday, April 9, 2018 7:17 PM

    2012

    you're rather limited there to be honest.
    If you can upgrade the nodes to Windows 2016 you'll...

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

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

    April 10, 2018 at 3:28 am

    #1986076

Viewing 15 posts - 316 through 330 (of 9,244 total)