Forum Replies Created

Viewing 15 posts - 1,876 through 1,890 (of 9,244 total)

  • RE: SQL Server 2012 R2 Installation in Windows Server 2012 R2

    keshab.basnet (7/22/2015)


    Can i install SQL Server 2012 Fail-over clustering in windows server 2012 R2 Virtual machine

    If the vm is part of a windows 2012 R2 cluster, then yes

    keshab.basnet (7/22/2015)


    Is it...

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

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

  • RE: FailOver Happened

    Arjun SreeVastsva (7/21/2015)


    yaa I am using both

    Have you checked the logs???

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

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

  • RE: Database Mirroring ERROR in SQL server 2012

    Database admin(DBA) (7/21/2015)


    Yes the account have full sysadmin permissions

    Which account

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

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

  • RE: Error installing SQL Server Database Engine Services Instance Features o

    What version of SQL server are you installing, is it an RTM installer?

    At what point during the install do you get the error?

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

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

  • RE: Database mirroring error

    see your question here

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

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

  • RE: DB mirroring transact-SQL error 1418, SQL Log error 1433 severity 16 state 2

    firstly check the windows firewall on both nodes.

    rcaballero (7/21/2015)


    But when I issue the ALTER DB SET PARTNER command

    what commands did you use to create the database mirroring endpoints on...

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

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

  • RE: Database Mirroring ERROR in SQL server 2012

    Database admin(DBA) (7/21/2015)


    Message

    Database Mirroring login attempt by user 'xxx\xxxSQL.(Domain account i.e,SQL server account running on this account)' failed with error: 'Connection handshake failed. The login 'xxx\xxxSQL' does not have CONNECT...

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

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

  • RE: table size difference in two DB

    mailtoashokberwal (7/20/2015)


    I am having an issue in determining the correct size of a table.

    I have a tableA in some DB on transaction server (Enterprise Edition), this table is being...

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

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

  • RE: Database Mirroring ERROR in SQL server 2012

    Database admin(DBA) (7/21/2015)


    Now suddenly the database status showing as principal server (Principal, Disconnected) and Mirror server (Mirror, Disconnected, In recovery).

    Have you checked the logs, do you see any...

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

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

  • RE: Window Failover cluster- For SQL Server Failover cluster

    Please return details of the following Powershell query

    Get-ClusterQuorum | ft Cluster, QuorumResource, QuorumType

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

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

  • RE: Can we add the disk on the fly in SQL Server cluster ?

    Windows 2003 used to require a restart of the clustered sql server resource when adding a disk as a dependency, Windows 2008 onwards doesnt

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

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

  • RE: FailOver Happened

    are you using alwayson availability groups or failover cluster instances or even both?

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

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

  • RE: Trying to backup log on High Availability Server

    are you using Alwayson availability groups?

    Are you attempting to backup the log on a secondary database?

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

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

  • RE: Cluster with Multiple instances on the same node

    Yuri55 (7/16/2015)


    Thanks Perry.

    On the second thought- this problem (2-nd instance should follow 1-st one after failover to another node) looks a bit confusing to me now. I mean main reason...

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

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

  • RE: Database Mirroring hates me - Attempt no1

    DBA on Route (7/17/2015)


    Short version: Learning.

    Ok, its ideal for that

    DBA on Route (7/17/2015)


    I also beleive that understanding Mirroring will help me understand AlwaysOn technology which has a while left until...

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

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

Viewing 15 posts - 1,876 through 1,890 (of 9,244 total)