Forum Replies Created

Viewing 15 posts - 2,371 through 2,385 (of 9,244 total)

  • RE: SQL 2012 Always ON

    p.swathi4 (2/12/2015)


    I am trying to configure SQL Always ON.I am getting an SQL server error 19471. I am having issue in creating Listener but rest all steps are succesful.And when...

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

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

  • RE: Restore an ecnrypted sql server 2014 backup via GUI

    Hmm, I thought so. This is not exactly a bug, although BOL should explain a little better what happens when you restore a DMK :angry:

    When you restore the DMK from...

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

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

  • RE: Restore an ecnrypted sql server 2014 backup via GUI

    Igor Micev (2/10/2015)


    I have restored the master key from the instance where the encrypted backup was created on the instance where I want to restore the encrypted backup

    Just out of...

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

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

  • RE: Copy data from one schema to another

    SmilingLily (2/12/2015)


    Hi - I have a database DB1 and DBTest

    DBTest Database is empty. I want to copy all the objects in DB1 - schema1 how can I do that?

    backup and...

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

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

  • RE: Help with SQL Clustering - complicated example

    slk55guy (2/12/2015)


    Actually having had a re-think, perhaps, as you say, i would utilise the VM HA clustering.

    A WSFC does not exist until you join a set of Windows nodes together...

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

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

  • RE: Help with SQL Clustering - complicated example

    slk55guy (2/12/2015)


    Can I have multiple 2 node FCIs running under ONE WSFC with independent failover?

    Yes, again each clustered role is totally independent

    slk55guy (2/12/2015)


    Also, some whitepapers i have read have...

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

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

  • RE: master.dbo.xp_delete older backup files not deleted

    also, try using the following as the extension

    N'BAK'

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

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

  • RE: master.dbo.xp_delete older backup files not deleted

    SQL Galaxy (2/11/2015)


    SQL Agent service running under domain account, so this account already added into Local administrators group and also have sufficient privileges.

    Open explorer and check the privileges assigned,...

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

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

  • RE: Help with SQL Clustering - complicated example

    FCIs are created as completely separate cluster roles and failover independently.

    It may pay you to read through my AlwaysOn stairway starting at this link[/url] to get a better understanding of...

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

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

  • RE: High availability for SSRS on SQL Cluster 2012?

    ApolloDB (2/12/2015)


    So what does "highly available web farm exactly means": in addition to the existing sql cluster i need 2 or more servers with SQL Server Enterprise Edition, right?...

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

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

  • RE: Database mirroring.

    the transactions are transferred via the mirroring endpoints and a redo thread on the mirror applies the transactions.

    What exactly is it you want to do?

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

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

  • RE: Help with SQL Clustering - complicated example

    slk55guy (2/12/2015)


    summary

    •A single Windows Server Failover Cluster (WSFC) at Host ESX level (Operating system level)

    •Two ESX Hosts in the above single cluster

    It won't be a WSFC, the 2 ESX hosts...

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

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

  • RE: High availability for SSRS on SQL Cluster 2012?

    midejan (2/12/2015)


    Hi,

    We are trying to determine how to provide SSRS for high availability since is not cluster aware.

    Putting it into a highly available web farm is the way to go

    midejan...

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

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

  • RE: Always On - SQL Server 2012 Enterprise edition - Does Requires to pay for an extra license?

    APA0876 (2/11/2015)


    HI I'm new on this, but the business wants to implement it as a DR alternative:

    Please can you guide me? or provide me a reference where I can find...

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

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

  • RE: Two Node WSFC on a multi subnet is there any need for a file share if we do not want automatic failover

    It's all about interpretation of the text and these are the points you're missing here

    Reg_Mayfield (2/11/2015)


    Voting and Non Voting Nodes

    By default, each node in the WSFC cluster is included as...

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

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

Viewing 15 posts - 2,371 through 2,385 (of 9,244 total)