Forum Replies Created

Viewing 15 posts - 3,451 through 3,465 (of 9,253 total)

  • RE: Maximum cluster nodes in SQL AlwaysOn

    glugingboulder (3/17/2014)

    Thanks for reply, i understand that part, but what if you have this example.

    10 node windows cluster

    Availability group 1 spans nodes 1 -5.

    Availability group 2 spans nodes 5-10.

    Essentially you...

    March 19, 2014 at 5:15 am

    #1698321

  • RE: Database Mirroring scenario

    zedtec (3/19/2014)

    Hi Perry,

    No confusion.....Failover is performed at the principal server isn't it?

    No, not when the principal is dead as you quoted in your scenario above. In this case you would...

    March 19, 2014 at 5:12 am

    #1698317

  • RE: Problem logging on to Integration Services

    k.arkenau (3/19/2014)

    Ok, I changed that and added the User to the DCOM User group.

    Nevertheless, the user still cannot logon to the information services.

    Any idea?

    If you used distributed com users...

    March 19, 2014 at 1:49 am

    #1698258

  • RE: Database Mirroring scenario

    zedtec (3/18/2014)

    In relation to this, what happens if one of the site's goes down (i.e - the principal site) and automatic failover is not being used (i.e. - there is...

    March 18, 2014 at 10:32 am

    #1698116

  • RE: Mirroring and SQL Agent Job on principle

    to add to George, the old principal will become the mirror but the session will be suspended. You will need to manually resume mirroring using

    alter database [yourdb] set partner resume

    March 15, 2014 at 3:49 pm

    #1697448

  • RE: Mirroring and SQL Agent Job on principle

    smtzac (3/15/2014)

    Yes. Recovering the Database. I don't think you can switch Principle server to Mirror if Principle is down, can you?

    Yes of course you can, but it's a manual failover...

    March 15, 2014 at 10:06 am

    #1697429

  • RE: Transactional Log backup

    New Born DBA (3/14/2014)

    Just wanted to share my knowledge I have regarding transactional log and I am wondering if someone can answer me since I know just a little to...

    March 14, 2014 at 10:15 am

    #1697205

  • RE: Why are my logshipping files so large?

    what do you see if you query the active processes, anything apparent there

    March 14, 2014 at 10:13 am

    #1697204

  • RE: Always On with clustered disks

    singh.kamaldeep (3/13/2014)

    1) Do i need to have all the 4 nodes in same failover cluster group? If yes, then this would become MultiSubnet cluster Or Is there any way those...

    March 14, 2014 at 2:56 am

    #1697060

  • RE: Mirroring and SQL Agent Job on principle

    smtzac (3/13/2014)

    when principle server goes down (server level), in an asynchronous DB mirroring, what is the best option and/or steps for production environment?

    best option for what, are you referring to...

    March 14, 2014 at 2:51 am

    #1697058

  • RE: Database Mirroring - Principal Disconnected and FULL Backups

    nikhil.desai1 (3/11/2014)

    Hi,

    There are 2 server A (principal) and B(Mirror) -Synchronous Mode without automatic fail-over. When principal A goes down Mirror B database is brought up using command

    ALTER DATABSE SET PARTNER...

    March 14, 2014 at 2:48 am

    #1697056

  • RE: Database Mirroring scenario

    zedtec (3/13/2014)

    Hi,

    I just wanted to know what would happen in the scenario where you've got database mirroring configured over a WAN and one site goes down and loses connection with...

    March 13, 2014 at 4:05 pm

    #1696981

  • RE: Mirroring and SQL Agent Job on principle

    smtzac (3/13/2014)

    Hi all,

    I am configuring DB mirroring on principle database and the database has Full,Diff,TranLog backups job running everyday on Sql Agent.

    In order to configure Mirroring on principle database...

    March 13, 2014 at 3:55 pm

    #1696980

  • RE: AG Failover Order

    Just to clear any confusion, you may have more than 2 synch replicas. However, only 2 synch replicas may be configured for auto failover at any one time, any attempt...

    March 13, 2014 at 10:51 am

    #1696879

  • RE: SQL 2005 Mirroring Database Synchronization status after disaster

    Lempster (2/18/2014)

    As soon as the new Mirror (former Principal) is back online, the mirroring session will resume and the Mirror will be in a Synchronizing state.

    The mirror session will be...

    March 13, 2014 at 10:24 am

    #1696867

Viewing 15 posts - 3,451 through 3,465 (of 9,253 total)