Forum Replies Created

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

  • RE: How to see foreign key relationship

    Fill your boots mate, I'd appreciate your input 😉

    January 20, 2014 at 11:38 am

    #1681653

  • RE: Upgrading from SQL 2012 Standard to 2012 Enterprise

    I wouldn't have thought so if you're smart you'll take backups before you begin.

    January 20, 2014 at 11:29 am

    #1681652

  • RE: Copy logins with their password

    The script doesn't carry server permissions, but with a little imagination and querying the correct catalogs its easy to accomplish.

    January 20, 2014 at 11:26 am

    #1681650

  • RE: AlwaysOn config?

    That's because they don't under stand how multi node clusters are configured and operate 😉

    January 20, 2014 at 10:20 am

    #1681639

  • RE: 3-Node, 3-Instance SQL Cluster -- Static IP address and Port 1433 question

    jpSQLDude (3/28/2013)

    I searched hard and many people have a similar question, but I cannot find a clear answer. I have a 3-node Windows Server 2008 R2 cluster, with 3 Named...

    January 20, 2014 at 10:18 am

    #1681638

  • 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...

    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...

    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...

    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...

    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...

    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...

    January 20, 2014 at 8:16 am

    #1681575

  • RE: AlwaysOn config?

    Are the two clustered instances on separate Windows clusters?

    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...

    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...

    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...

    January 20, 2014 at 7:20 am

    #1681534

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