Forum Replies Created

Viewing 15 posts - 1,246 through 1,260 (of 9,253 total)

  • RE: AlwaysOn connections

    vincenzo_capelli (5/27/2016)


    Hi,

    I have implemented AlwaysOn, now before to switch on secondary replicas I would like to be sure all applications have been modified to connect into the AlwaysOn listener.

    Do you...

  • RE: How to do an Active/Active server setup in sql server 2012.

    sudhakar_1982 (5/21/2016)


    Hello,

    Please give me a best solution with combined the below feature in sql server 2012. i.e. High Availability + Load balancing + Fail over.

    At least 2 database servers, both...

  • RE: AlwaysOn failover with domain users and groups

    Super_Grover (5/26/2016)


    Hi all, I'm new here but cerainly not new to sql server. Originally I'm a programmer (vb.net, c#, sql mainly) but more and more I am being moved by...

  • RE: Unusually large Differential Backups

    GilaMonster (5/31/2016)


    A copy-only backup won't affect the size of differentials.

    What else happened around the same time? Index rebuilds?

    or emptying and loading of large tables maybe

  • RE: Always On Readonly

    Rechana Rajan (5/29/2016)


    Have created a always on setup in which 3 nodes are involved 2 in SQL server Failover Cluster and 1 Always On AG.

    I have connected to the listener...

  • RE: Availability groups

    Roust_m (5/29/2016)


    Hi,

    We are considering using availability groups for our solution. It will have 4 SQL Server 2014 instances running on 4 cluster nodes, spread across two cities (two nodes...

  • RE: Physical Move of Secondary Replica to a new Location

    you could pause data movement at the secondary, either way just be aware of the impact on the transaction log on the primary as growth may become an issue, depending...

  • RE: SQL back Job is failing

    ramana3327 (5/27/2016)


    Hi,

    I created a maintenance plan for backup. The job is failing with the error

    The job failed. The owner (TestUser) of job MaintenancePlan.Subplan_1 does not have server access.

    The TestUser...

  • RE: Microsoft best practice for ssd

    Igor Micev (5/31/2016)


    Grant Fritchey (5/31/2016)


    TheSQLGuru (5/31/2016)


    Igor Micev (5/31/2016)


    My experience with SSDs on a write-intensive instance was very bad. The SSDs went out for 2 months.

    What SSDs did you have? What...

  • RE: Clustering Issue

    what FailureConditionLevel do you have set for the Availability group

  • RE: Move Systemdatabases

    You only mention TempDB, is this the only system database you wish to move?

    To move tempdb correct sequence is

    tt-615680 (5/16/2016)


    1. Check the location of the tempdb files

    Use master

    GO

    ...

  • RE: SSRS Server install

    sqlfriends (5/16/2016)


    3. My question is on server2, is it a third method to install only SSRS service on server 2 no db engine, and put reporting dbs on Server 1

    yes...

  • RE: Installing SQL Server 2012 on Server Core 2008

    what operating system are you installing onto?

    Refer this link for more detail

  • RE: Binary Compare

    Bob JH Cullen (5/17/2016)


    then 0x00 is clearly not the same as 0x0000, the way it is written.

    I see it to be a single nothing or a whole bunch of nothing...

  • RE: Binary Compare

    Bob JH Cullen (5/17/2016)


    which in any integer expression are irrelevant, surely?

    This is not an integer expression.

    The code first checks the binary values for @a and @b-2, do they match, well...

Viewing 15 posts - 1,246 through 1,260 (of 9,253 total)