Forum Replies Created

Viewing 15 posts - 3,706 through 3,720 (of 9,244 total)

  • RE: AlwaysOn config?

    david.alcock (1/20/2014)

    Yes and that's where the issue lies as the DR (SQL instance) sits on the pre-production (windows) cluster, so yes we'd have to have that within the same cluster...

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

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

    January 20, 2014 at 9:59 am

    #1681632

  • RE: How to see foreign key relationship

    spectra (1/19/2014)

    I want to see foreign key relationship of a table say student_tbl

    I want to see which tables are connected with this.

    what is the query to see the...

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

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

    January 20, 2014 at 9:42 am

    #1681630

  • RE: AlwaysOn config?

    david.alcock (1/20/2014)

    In order to utilise AlwaysOn, we would need to add each node (of each cluster) to ONE cluster. Then we can set up the roles of each server...

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

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

    January 20, 2014 at 9:11 am

    #1681613

  • RE: AlwaysOn config?

    david.alcock (1/20/2014)

    Am I right in thinking that if we had disk replication then we could add the other node into an availability group?

    I have spent some time looking into this...

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

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

    January 20, 2014 at 8:54 am

    #1681604

  • RE: SQL 2008 failover 2 node (A/P) license upgrade from STD to ENT

    Spud312R (1/20/2014)

    Many thanks for this, is there a procedure if i need to rollback to std from ent editions?

    Same again i believe, which would then downgrade and possibly lose features...

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

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

    January 20, 2014 at 8:44 am

    #1681594

  • RE: AlwaysOn config?

    david.alcock (1/20/2014)

    There are 2 separate clusters, production at the main site and pre-production that has 2 SQL instances on it (pre-production and disaster recovery).

    D

    Although it's possible to create an AlwaysOn...

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

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

    January 20, 2014 at 8:16 am

    #1681575

  • RE: AlwaysOn config?

    Are the two clustered instances on separate Windows clusters?

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

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

    January 20, 2014 at 7:41 am

    #1681548

  • RE: Multiple Availability Group Listeners - best practice to define ports?

    Even though the combination of the IP address and port number are unique, I would avoid using the std port number for the listener, I prefer to assign a free...

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

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

    January 20, 2014 at 7:30 am

    #1681540

  • RE: AlwaysOn config?

    david.alcock (1/20/2014)

    Hi all, I posed a similar question previously and with a little bit more understanding, I'm still none the wiser!!

    Presently we have a SQL 2008 R2 cluster, the main...

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

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

    January 20, 2014 at 7:26 am

    #1681539

  • RE: Copy logins with their password

    george sibbald (1/20/2014)

    Perry Whittle (1/20/2014)

    SQL_Surfer (1/17/2014)

    I need to copy some databases from one server to another. What is the best way to copy logins with their passwords? Each login has...

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

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

    January 20, 2014 at 7:20 am

    #1681534

  • RE: Multiple Availability Group Listeners - best practice to define ports?

    your setup is not clear from your description

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

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

    January 20, 2014 at 7:04 am

    #1681525

  • RE: Always On

    The only time shared storage comes into play is when you incorporate an FCI as an AlwaysOn replica

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

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

    January 20, 2014 at 6:33 am

    #1681511

  • RE: Clustering

    ramana3327 (1/18/2014)

    Hi,

    Please let me know the main difference b/n Microsoft Clustering & Veritas Clustering.

    What is the use of Domain controller in clustering? I mean is it mandatory to create domain...

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

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

    January 20, 2014 at 6:30 am

    #1681510

  • RE: Upgrading from SQL 2012 Standard to 2012 Enterprise

    launch the installation media and in the installation centre there is an option to upgrade the SQL Server edition. Should be fairly painless to complete

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

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

    January 20, 2014 at 6:21 am

    #1681505

  • RE: Insert or update

    could it be the OP is actually confused and is really enquiring about the MERGE option?

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

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

    January 20, 2014 at 6:11 am

    #1681500

Viewing 15 posts - 3,706 through 3,720 (of 9,244 total)