Forum Replies Created

Viewing 15 posts - 1,711 through 1,725 (of 9,244 total)

  • RE: SQL Server 2012 Group Listner / Read-only intent

    what TCP port number did you use for the Listener

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

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

    September 25, 2015 at 5:08 am

    #1829395

  • RE: AlwaysOn transaction error 9002: the transaction log for database '' is full due to 'AVAILABILITY_REPLICA'

    chrisph (9/24/2015)

    @Jackin, how do you force a checkpoint?

    execute the following query in your chosen database

    Checkpoint

    chrisph (9/24/2015)

    @perry, 4 databases, one large one is causing the errors.

    Full and log backups are set...

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

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

    September 25, 2015 at 5:06 am

    #1829393

  • RE: Questions on AlwaysoNAvailability groups

    nari.koud (9/24/2015)

    I have Configured always on Availability groups between Server 1 Primary Replica(Active), server 2 Secondary Replica(Passive) on top of WCFS...

    Listener Name: AGListner( CLIENTS/APPLICATIONS connect using this Name)

    Testing Scenario...

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

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

    September 25, 2015 at 4:49 am

    #1829390

  • RE: SQL 2012 FCI With AG.

    You're in conflict here

    PretendDBA (9/22/2015)

    Really all I want is an async readable replica.

    PretendDBA (9/22/2015)

    Not interested in read offload

    PretendDBA (9/22/2015)

    as long as we test it and confirm the replica db never...

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

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

    September 24, 2015 at 9:24 am

    #1829183

  • RE: Basic Log Shipping questions

    Siten0308 (9/23/2015)

    1. has a database about 100gigs ish, but the transaction log file are about 5-10kb, I want to log ship from prime location to secondary, will I run into...

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

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

    September 24, 2015 at 9:18 am

    #1829180

  • RE: SQL AG making the secondary the new primary...

    balcock (9/23/2015)

    "If we fail over a SQL AG group on a failover cluster from one node to another making the secondary the new primary, is there any reason why we...

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

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

    September 24, 2015 at 9:12 am

    #1829178

  • RE: SQL Server 2012 Group Listner / Read-only intent

    nemesis101 (9/23/2015)

    Hello Community,

    I have a concern in regards to AG and read-only intent.

    So have I have an environment with 2 nodes, setup under AlwaysOn.

    Everything is establish, but I'm concern in...

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

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

    September 24, 2015 at 9:11 am

    #1829176

  • RE: fastest mode to move a 2012 cluster

    Hadrian (9/24/2015)

    I come back with some details- we have two node cluster 2012 and we should move on new SQL cluster 2012 with disks on the...

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

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

    September 24, 2015 at 9:05 am

    #1829173

  • RE: AlwaysOn transaction error 9002: the transaction log for database '' is full due to 'AVAILABILITY_REPLICA'

    chrisph (9/23/2015)

    Bumping this. I am still receiving the 'availability_replica' errors and backups do not resolve this, I need to remove the database from the availability group first and re-add...

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

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

    September 24, 2015 at 9:02 am

    #1829171

  • RE: SQL Server 2014 - Principal.Synchronized databases are not all on primary server...

    how many nodes in the cluster?

    mirroring or AO groups?

    etc etc

    Throw a dog a bone here

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

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

    September 22, 2015 at 9:26 am

    #1828469

  • RE: How to move some of the database data from environment to environment?

    either move the whole database or maybe use replication if it's an option, depends on your requirements and environment

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

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

    September 22, 2015 at 9:24 am

    #1828467

  • RE: Log Shipping

    NT AUTHORITY\Network service account acts as the computer on the network, any remote shares accessed by the sql server service will need the computer account to be granted privileges.

    A domain...

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

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

    September 22, 2015 at 8:53 am

    #1828441

  • RE: SQL 2008 Cluster Installation - SPN Issue

    riazjee-993186 (9/22/2015)

    Dear All,

    I am trying to setup a 2-Node SQL 2008 Cluster on Windows 2008R2 (64-bit) using the sliptstream (SP3). I am getting the following error in the end:

    The cluster...

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

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

    September 22, 2015 at 8:44 am

    #1828434

  • RE: SQL 2012 FCI With AG.

    Firstly, ready through my stairway to HA on this site starting at this link

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

    PretendDBA (9/21/2015)

    It seems the only real way to achieve an as live fully offloaded DB for reporting...

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

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

    September 22, 2015 at 8:42 am

    #1828432

  • RE: Change SQL Server 2012 Collation

    Wooju (9/22/2015)

    Hello,

    I also need to change the server collation. I have a 2 node, 2 instance SQL 2012 SP1 cluster. I tried to run the sqlservr -m -T4022 -T3659...

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

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

    September 22, 2015 at 8:33 am

    #1828426

Viewing 15 posts - 1,711 through 1,725 (of 9,244 total)