Forum Replies Created

Viewing 15 posts - 6,346 through 6,360 (of 9,241 total)

  • RE: Removal of a node from Cluster

    the setup process has changed totally

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

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

    October 21, 2011 at 4:43 am

    #1397846

  • RE: Database Mirroring

    kapfundestanley (10/20/2011)

    I have mirrored my 10 databases but i know at a time in future my database would grow to maybe terabytes...will mirror still be sustanable?What measures should i put...

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

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

    October 21, 2011 at 4:15 am

    #1397837

  • RE: Database mirroring error

    philip.nash (10/21/2011)

    Hi,

    I'm receiving the following error when trying to set up mirroring on a database.

    Database Mirroring login attempt by user 'domain\user.' failed with error: 'Connection handshake failed. The login...

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

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

    October 21, 2011 at 4:13 am

    #1397836

  • RE: Database Mirroring timeout setting

    instead of stopping services test by interrupting the networking on the principal. You could do this by disabling the network card

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

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

    October 21, 2011 at 4:01 am

    #1397832

  • RE: cluster failover - Unknown,Open of fault log D:\Microsoft SQL Server\MSSQL.1\MSSQL\log\exception.log failed.

    there should also be a .log file too with the same name, whats in there?

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

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

    October 21, 2011 at 3:53 am

    #1397829

  • RE: Removal of a node from Cluster

    itsamarnath (10/21/2011)

    Thanks. Isn't there a need to run setup on node C also and do the manage virtual cluster procedure there?

    Coz, Our Inst1 is currently not recognized on Node C?

    no,...

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

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

    October 21, 2011 at 3:52 am

    #1397828

  • RE: Removal of a node from Cluster

    itsamarnath (10/21/2011)

    Perry Whittle (10/21/2011)

    itsamarnath (10/21/2011)

    We have a 3 node cluster..Lets say, the names of nodes are A, B and C

    We have 2 instances running Inst1 and Inst2 on these nodes..Both...

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

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

    October 21, 2011 at 3:43 am

    #1397822

  • RE: Dropping BuiltIn/Administrator and SA from SQL Server

    DMarvez (10/19/2011)

    So, we got a request to drop these two users from SQL Server as part of a corporate security effort.

    I've read the post on the BuiltIn\Administrator account but can't...

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

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

    October 21, 2011 at 3:40 am

    #1397820

  • RE: Restrict node to failover to particualar node.

    be aware that preferred owner is set at the group level, possible owner is set at each resource level

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

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

    October 21, 2011 at 3:32 am

    #1397818

  • RE: Removal of a node from Cluster

    itsamarnath (10/21/2011)

    We have a 3 node cluster..Lets say, the names of nodes are A, B and C

    We have 2 instances running Inst1 and Inst2 on these nodes..Both are SQL Server...

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

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

    October 21, 2011 at 3:29 am

    #1397813

  • RE: DB Mirroring question?

    high availability is the only mode that can use FailOverPartner as the other modes are manually failed over, with the witness it's automatic and so requires the connection string option...

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

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

    October 20, 2011 at 4:21 am

    #1397194

  • RE: DB Mirroring question?

    ananda.murugesan (10/20/2011)

    please suggestion me, What changes required in ASP web application for database connectivity? whenever modify ALTER DATABASE MyDB SET PARTNER FAILOVER.

    Thanks

    ananda

    The instance name in the connection string would obviously...

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

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

    October 20, 2011 at 4:09 am

    #1397183

  • RE: DB Mirroring question?

    ananda.murugesan (10/20/2011)

    please suggestion me, What changes required in ASP web application for database connectivity? whenever modify ALTER DATABASE MyDB SET PARTNER FAILOVER.

    Thanks

    ananda

    The instance name in the connection string would obviously...

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

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

    October 20, 2011 at 4:06 am

    #1397182

  • RE: DB Mirroring question?

    This will remove the mirror session!

    kapfundestanley (10/20/2011)

    You have to do a manual fail-over

    On the mirror

    ALTER DATABASE <database name> SET PARTNER OFF

    RESTORE DATABASE <database name> WITH RECOVERY

    when the principal...

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

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

    October 20, 2011 at 3:08 am

    #1397142

  • RE: How to install SQL Server SP4 on a Cluster environment???

    Imaan (10/19/2011)

    Thank you for your help, I shall check the task schedulers on both sides, this explains the logic of how the SP gets applied to active/passive.

    We have 2...

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

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

    October 19, 2011 at 9:55 am

    #1396748

Viewing 15 posts - 6,346 through 6,360 (of 9,241 total)