Forum Replies Created

Viewing 15 posts - 241 through 255 (of 332 total)

  • RE: database mirroring

    A quick read through the (overly-long) notes tells me that you are trying to create ALL the endpoints on TCP/4040.

    That is fine if each MSSQL Instance is on a separate...

  • RE: Reg: MCTS EXAM 70-445

    Completely agree. You won't help yourself by relying on brain dumps to pass an exam. If you want a certification to help get a job in a specific area, first...

  • RE: MCITP DBA numbers - so few

    Like you, I am very surprised at the numbers. In particular, there are:

    150,000 Database Administrators (MCDBA) for SQL Server 2000

    4,400 Database Administrators (MCITP) for SQL Server 2005

    Considering...

  • RE: Encrypting Data

    Whilst Steve is quite correct in saying that managing the encryption/decryption keys is the hard part, it doesn't need to be *that* hard.

    PKI, Public Key Infrastructure, is designed specifically for...

  • RE: Mirror failover breaks transactional replication

    Interesting.

    Just to confirm, when you say Port Number, do you mean for the SQL Database Server, or for the Mirroring EndPoints?

  • RE: UK Cultures

    And note that the UK's favourite dish is Chicken tikka masala....

  • RE: registration

    hmm, interesting. Given that roughly the same thing happens in multiple browsers, the problem must lie either with the OS, or how you connect to the outside world. Are you...

  • RE: Creating SQL Servers on VMware

    Thanks Luke, very interesting white paper.

    I am genuinely surprised that this works. All my previous encounters with Microsoft Cluster setup have been severely restricted by the requirements demanded by Microsoft,...

  • RE: Creating SQL Servers on VMware

    If you want the experience of installing MSSQL Server, then a reinstall is worth doing. But otherwise, try doing a snapshot in VM - it is surprisingly easy and quick.

  • RE: registration

    Can you try the same thing using a different browser?

    How about if you add the SQL Server Central URL as one of your trusted sites in IE?

  • RE: Creating SQL Servers on VMware

    Sounds like a nice-enough laptop, although I'm slightly surprised that it is not a Core 2 Duo?

    Certainly VMware will be able to snapshot your current 3 desktops and create Virtual...

  • RE: Database Mirroring - keeping logins/jobs etc. up to date

    If the application makes use of a DSN, then choose "SQL Native Client". You can configure a Mirror with this DSN. The SQL Native Client could work with all VB...

  • RE: Graduated..working..now what?

    Dear The underdog,

    Don't take this the wrong way, but how on earth did you land the job of Data Warehouse Architect? You are candid about your skills, which is great....

  • RE: Adding Witness Server in Mirroring

    I suspect that you have a problem with the configuration of the Endpoint for your Witness. Are you able to run through the "Configure Database Mirroring Security Wizard", successfully configuring...

  • RE: Mirroring In sql server 2005- Witness Full Quorum

    Hi there,

    If you run:

    select * from sys.database_mirroring

    on the Principal and the Mirror, check the following values. For a normal, synchronised mirror with Witness, the values should be:

    -- mirroring_state =...

Viewing 15 posts - 241 through 255 (of 332 total)