Forum Replies Created

Viewing 15 posts - 2,551 through 2,565 (of 9,241 total)

  • RE: Windows Server 2012. How do I do a System Restore to a previous restore point

    full machine backup (system state and app drives)

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

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

  • RE: 2 SQL FCIs and 1 HAG

    SQLKnowItAll (12/30/2014)


    All that being said, do you have any further thoughts?

    Yes, if your cluster was a 3 node cluster you wouldnt need a disk based quorum, Majority Node Set would...

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

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

  • RE: 2 SQL FCIs and 1 HAG

    SQLKnowItAll (12/30/2014)


    Also, all 4 nodes are part of the same WSFC. (also edited to make clearer)

    ok, that wasn't clear before

    SQLKnowItAll (12/30/2014)


    Do your comments still apply? I.e., In order for the...

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

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

  • RE: Establishing a mirror - between 2005 and 2008 R2 (standard) - error 1478

    matt.newman (12/12/2014)


    The problem is here that I can't get this one, bigger, more transaction heavy DB to mirror. 27 other databases I can get, but this 1 single DB is...

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

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

  • RE: 2 SQL FCIs and 1 HAG

    SQLKnowItAll (12/29/2014)


    We are building architecture to have 2 FCIs set up in a HAG.

    Setup:

    Hypervisor = VMWARE

    OS = SQL 2012 R2

    SQL = SQL Server 2012 Enterprise Ed. (of course)

    SAN =...

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

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

  • RE: Database Mirroring Monitor - Registered Databases Question

    1433 is the default port, do you havce TCP\IP enabled?

    Have you installed a default or named instance?

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

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

  • RE: Trouble shoot Always on

    ramyours2003 (12/29/2014)


    Thanks for the reply, apart of the dashboard is any DMV's to trouble the Always on

    Yes, a shed load!!!

    Really, a simple google search is all you...

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

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

  • RE: Trouble shoot Always on

    The dashboard would be one way, have you looked at this?

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

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

  • RE: Restrict access to Database

    saum70 (12/27/2014)


    Hello,

    Previously we used to store sql user logins in registry or xml for our applications(made in C#) to access the database. Now we are proposing that the application be...

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

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

  • RE: SQL Server 2012 Always On With FCI

    nlion84DBA (12/26/2014)


    Follow on. Found the sequesnce. Pretty straightfoward, eh?

    1. Evict the standalone node

    2. Install SQL Server

    ...

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

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

  • RE: re-vamping data files in a production database

    Firstly, are both files in the same filegroup??

    sextonk (12/23/2014)


    It is my understanding that is a best-practice. To have multiple data files which are the same size. Performance should be better,...

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

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

  • RE: manual failover availability group

    both replicas must be configured for synch mode and automatic failover, check the AO group properties

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

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

  • RE: Invalid Network name error while doing Sql 2012 Clustering

    sej2008 (12/23/2014)


    I am working with administrator account at domain level.I think you do not need extra permission to be configured for this account in AD am I right?

    as pointed out,...

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

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

  • RE: High availabilty

    already answered here.

    Please stop blindly posting in multiple forums, are you using SQL 2012 or 2014????

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

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

  • RE: error 41105 while working with Always on

    if you're having issues with networking have your network admin help you

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

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

Viewing 15 posts - 2,551 through 2,565 (of 9,241 total)