Forum Replies Created

Viewing 15 posts - 1,771 through 1,785 (of 9,244 total)

  • RE: Always on

    Please post in the correct forum for faster results.

    Do the data file locations on the primary and secondary(s) match?

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

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

  • RE: LogShipping Dynamic Port Number

    Log shipping uses a set of top ports for fileshare access and for the awl server instance, what ports are you referring to?

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

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

  • RE: How to restore the 'master' database while SQL Server is down

    Have you tried uninstalling the offending patch first from add\remove programs

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

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

  • RE: Log Shipping issues - 2 Secondaries

    SQLSACT (9/2/2015)


    Perry Whittle (9/1/2015)


    Has the copy job ever run successfully on the new secondary

    It runs successfully but takes a very long time, the restore job runs much longer as well,...

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

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

  • RE: What is strongest encryption algorithms in SQL Server 2012

    Of the built in, AES is the strongest, what exactly are your requirements.

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

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

  • RE: Always on and a reporting solution

    Steve-3_5_7_9 (8/27/2015)


    For the reports, use the paramenter "applicationintent=readonly" and that will send the reports to the secondary replica.

    Note that this must be preceded by accurate configuration of the read only...

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

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

  • RE: Can't release space of temdb

    Perry Whittle (8/31/2015)


    Welsh Corgi (8/31/2015)


    I'm going to have to start the SQL Server Agent Service.

    why did you stop it in the first place?

    What is the default size for your tempdb...

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

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

  • RE: dynamic quorum

    muthyala_51 (8/31/2015)


    Windows server 2012 R2 Standard

    yes, it's a multi site cluster with two nodes in one data center and another in a different data center. We disabled vote for the...

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

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

  • RE: Log Shipping issues - 2 Secondaries

    Has the copy job ever run successfully on the new secondary

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

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

  • RE: dynamic quorum

    muthyala_51 (8/30/2015)


    We have a two node windows cluster with file share witness. We had to reboot secondary replica and for some reason we lost connection to file share at the...

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

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

  • RE: SQL with High availability, disaster recovery and online (read only) reports availability

    shamshad.ali (8/31/2015)


    I need some links if you can share. Please don't mind. I want to learn.

    Please see my stairway series starting at this link

    http://www.sqlservercentral.com/articles/Failover+Clustered+Instance+(FCI)/107536/[/url]

    shamshad.ali (8/31/2015)


    Its all I want to learn...

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

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

  • RE: Can't release space of temdb

    Welsh Corgi (8/31/2015)


    I'm going to have to start the SQL Server Agent Service.

    why did you stop it in the first place?

    What is the default size for your tempdb files and...

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

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

  • RE: Convert standalone 2008 r2 server to cluster

    Part-time DBA (8/26/2015)


    Thanks. What confused me a little is that in my test environment I seem to have ended up with what appears to be a working copy of reporting...

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

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

  • RE: Command for adding new drives?

    JaybeeSQL (8/27/2015)


    GilaMonster (8/26/2015)


    That would be a far better question, because there's no SQL command to add drives to a server. 😉

    Firstly, you don't want to move the binaries, as that...

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

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

  • RE: Database Mirroring. Mirror server to be unavailable for 4 hours. What to do?

    simeharr (8/27/2015)


    Thank you for your thorough reply.

    You're welcome

    simeharr (8/27/2015)


    This seems to contradict the TechNet documentation

    Synchronous operation is maintained in the following manner:

    1. On receiving a transaction from a client, the...

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

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

Viewing 15 posts - 1,771 through 1,785 (of 9,244 total)