Forum Replies Created

Viewing 15 posts - 6,796 through 6,810 (of 9,244 total)

  • RE: Physical CPU or Logical Processors ?

    Oracle licence per core and get away with it, shouldn't think it will be long before MS capitalise on it too

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

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

  • RE: Need advise on backup huge monster DB

    Michael Valentine Jones (8/17/2011)


    You should consider moving to SQL Server 2008 (or R2) Enterprise Edition

    given the costs it may just be worth spending the few hundred dollars on a licence...

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

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

  • RE: Need advise on backup huge monster DB

    Grant Fritchey (8/17/2011)


    I know just the tool for the job...

    😀 hmm, let me think now i wonder what it could be 😉

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

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

  • RE: Moving Server to a new domain

    sql server user accounts won't be affected but windows accounts including any service accounts may need to be addressed

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

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

  • RE: Need advise on backup huge monster DB

    Steve Jones - SSC Editor (8/16/2011)


    Best advice, use backup compression first. If you have Enterprise Edition, you can use that

    not available in SQL Server 2005, you will need a 3rd...

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

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

  • RE: If you could use xp_CmdShell securely, would you?

    Jeff Moden (8/17/2011)


    Perry Whittle (8/17/2011)


    Its always been given bad press in the past due to the vulnerability. Its a feature hackers knew was there and could be exploited to harmful...

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

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

  • RE: Mirroring in High Safety Mode (?)

    DBAgal (8/17/2011)


    So, if the mirror database is offline and can't acknowledge the transaction right away, the transactions just continue to queue up until the mirror database becomes available? The...

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

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

  • RE: Mirroring in High Safety Mode (?)

    Loss of the mirror

    If the mirror fails, the principal continues functioning, but the mirroring state is

    DISCONNECTED and the principal is running exposed. Once the mirror database

    becomes operational, it automatically assumes...

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

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

  • RE: Log File not clearing

    Andrew Theodore (8/16/2011)


    Just so everyone knows, restarting a second time allowed the DB to be shrank. Not sure why it didn't happen with the first reboot.

    would of been handy to...

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

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

  • RE: If you could use xp_CmdShell securely, would you?

    Its always been given bad press in the past due to the vulnerability. Its a feature hackers knew was there and could be exploited to harmful use.

    I have an...

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

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

  • RE: Database Mirroring Port Config.

    Have you configured the security for the mirroring session

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

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

  • RE: Database Mirroring Port Config.

    Have you configured the security for the mirroring session

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

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

  • RE: Database Mirroring Port Config.

    How are you configuring mirroring are you using scripts or the mirroring page on the database options?

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

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

  • RE: Mirroring in High Safety Mode (?)

    That's not entirely correct!

    High Safety - High Availability and High Safety - High Protection modes will still allow connections to the database even when there is a mirror failure.

    It's...

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

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

  • RE: Changing VM Resources for SQL 2008

    The OS rebuild when adding a new CPU only affected Windows 2000.

    2003 and 2008 should be fine just ensure the multi processor HAL is loaded 😉

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

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

Viewing 15 posts - 6,796 through 6,810 (of 9,244 total)