Forum Replies Created

Viewing 15 posts - 2,821 through 2,835 (of 9,244 total)

  • RE: AlwaysOn - Is a fileshare witness really needed?

    bbcolo22 (10/27/2014)


    I am using Windows 2012R2.

    Ok, Windows 2012 and 2012 R2 have a new feature called Dynamic Node Weight configuration. During a planned outage such as a shutdown the quorum...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: AlwaysOn - Is a fileshare witness really needed?

    bbcolo22 (10/27/2014)


    I have seen many recommendations stating that if you have an even number of nodes, then you should create a fileshare witness (for the 3rd quorum vote). I would...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Problems Installing SQL 2012 Cluster - System Volume Information error

    anthony.green (10/27/2014)


    Traditional lettered drives I believe.

    I didn't set the cluster up from a Windows perspective.

    You'd soon know when you run the installer by the free volumes offered and the shared...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Same SQL Server Instance name on two different Windows 2008 R2 servers

    lsalih (10/27/2014)


    Steve -

    Question for you, I know this is an old post but I was curious about where you have two different nodes (node1 and node2) and having two sql...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Problems Installing SQL 2012 Cluster - System Volume Information error

    are you using mounted volumes for your shared disks or traditional drive letter based volumes?

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: How to restore model database.

    rajeshjaiswalraj (10/27/2014)


    How to restore model database.

    My Instance was down i deleted model database file. I have .bak file. I tried to restore but its not working.

    1. I connected single user...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Availability Group Listener Port

    after a port change i would restart the listener using

    ALTER AVAILABILITY GROUP group_name RESTART LISTENER β€˜dns_name’

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Level 1: What is "SQL Server AlwaysOn"?

    quackhandle1975 (10/27/2014)


    Nice article, looking forward to the next in the stairway.

    qh

    Here you go

    http://www.sqlservercentral.com/articles/AlwaysOn/107537/[/url]

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Best Practices

    ramana3327 (10/23/2014)


    Is it possible to have AG created across multiple domains?

    Are the domains in the same AD forest?

    An always group is only supported across cluster boundaries for migration purposes only,

    ramana3327...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Best Practices

    ramana3327 (10/23/2014)


    If there are 2 SQL Instances (Replicas) running on the same node, can they being part of the same AG?

    No, all replicas in an always on group must...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: TDE and Mirroring

    if the services for both instances use the same account you shouldnt need to do anything, as the acct will be a sysadmin anyway

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: TDE and Mirroring

    smtzac (10/24/2014)


    Since I already have service account [SQL\SVC] created I DO NOT need this below step right??

    is the same svc account being used for the sql server services on the...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Restarting mirrored databases after patching

    domstrad (10/24/2014)


    The SQL is mirrored without a witness server

    HA is performed using VMotion

    If you're mirroring the database then the HA is at the sql server level, introducing VMotion will...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Redundancy

    mlorek (10/23/2014)


    Yes we have the funding we actually have a rather large budget and get a educational price break that is amazing.

    Ok cool, just wanted to check. Most educational organisations...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: TDE and Mirroring

    smtzac (10/23/2014)


    I already have a service account created in Logins: SQL\SVC.

    ---CREATE ENDPOINT <endpoint_mirroring>

    STATE = STARTED

    AS TCP ( LISTENER_PORT = 7023 )

    FOR DATABASE_MIRRORING (ROLE=PARTNER)-----

    If I run above script, I think,...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

Viewing 15 posts - 2,821 through 2,835 (of 9,244 total)