Forum Replies Created

Viewing 15 posts - 6,121 through 6,135 (of 9,244 total)

  • RE: Cluster Network Configuration IP Address - how to configure?

    You can either use a static IP address or a DHCP assigned IP address. I'm assuming you mean DHCP when you say IP address on the domain controller.

    If you assign...

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

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

  • RE: Microsoft Gold Certified Partner Companies - Horror Stories

    Jeff Moden (1/8/2012)


    Any "Gold" partner that has Gail Shaw working for them has got to be one of the good ones I was talking about. 🙂

    Aww Jeff you're just too...

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

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

  • RE: SQL coding techniques

    GilaMonster (1/8/2012)


    Yes it did (at least on 7, 8i and 9i), and iirc it was just += or maybe (+)= (its been a while),

    Certainly a (+) on 7 and 8...

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

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

  • RE: SQL coding techniques

    Thanks for clearing that up

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

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

  • RE: SQL coding techniques

    IIRC the older syntax is not supported in database compatibilty modes of 90 and higher

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

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

  • RE: mirror setup failed, but cannot delete mirror db

    To set up mirroring in a workgroup see the following link

    http://blogs.msdn.com/b/suhde/archive/2009/07/13/step-by-step-guide-to-configure-database-mirroring-between-sql-server-instances-in-a-workgroup.aspx

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

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

  • RE: mirror setup failed, but cannot delete mirror db

    Is your laptop part of a windows domain. You need to be able to provide and resolve FQDNs?

    To setup mirroring in a workgroup you need to take a different approach...

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

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

  • RE: mirror setup failed, but cannot delete mirror db

    winston Smith (1/8/2012)


    I tried to set up mirroring. I restored my backup to the mirror and left it in a NO RECOVERY state.

    You must take and restore at least one...

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

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

  • RE: Restoring Server Certificate to new instance

    winston Smith (1/8/2012)


    That procedure relies on a detatch andreattach of the db, so it's not really a backup and restore of a tde database. It's moving of a tde database....

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

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

  • RE: Restoring Server Certificate to new instance

    See my reply to your last post on this subject

    http://www.sqlservercentral.com/Forums/Topic1205594-1526-2.aspx

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

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

  • RE: Found ideal block size with SQLIO, what now?

    Also, Depending on the size of the disk you may want to consider using GPT over MBR.

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

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

  • RE: Microsoft Gold Certified Partner Companies - Horror Stories

    See, what I like about the Oracle and VMWare certs is the fact you can't just go take an exam off your own back. You have to attend an approved...

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

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

  • RE: Restoring Server Certificate to new instance

    As I pointed out on your last post you made on this topic, you only need the backup of the database and the backup of the certificate. Books online details...

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

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

  • RE: Outsourcing SQL Server Administration

    In my opinion outsourcing is fine for small companies who don't want the hassle of managing technologies directly.

    Larger companies should always look to retain their systems in house. I have...

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

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

  • RE: Restoring Server Certificate to new instance

    So instance A and B were running under separate user accounts, correct?

    Are you moving a TDE protected database from one instance to another?

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

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

Viewing 15 posts - 6,121 through 6,135 (of 9,244 total)