Forum Replies Created

Viewing 15 posts - 6,556 through 6,570 (of 9,241 total)

  • RE: storage issue (I think)

    what size is the file you are using?

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

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

  • RE: Set location of SQL System databases on installation

    i've answered this in your duplicate post

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

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

  • RE: installation of system databases to another location

    MarvinTheAndriod (9/23/2011)


    When you install SQL server 2005 where is the option to change the default installation of system databases to another location ? I sure it must be there but...

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

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

  • RE: Adding a node to Cluster - "No mapping between account names and security IDs was done."

    what messages do the individual logs show?

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

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

  • RE: Install MSDTC on a 2005 cluster

    no, it should however be installed first. In fact 2005 set up program would have flashed a warning that no clustered msdtc app was present

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

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

  • RE: Install MSDTC on a 2005 cluster

    you can, and in fact you should, install a clustered instance of MSDTC to handle any distributed transactions for the clustered SQL Server instance(s)

    you'll need a unique network name, IP...

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

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

  • RE: AWE Enabled but no gains in Memory Usage by SQL Server- Requesting Help

    I believe the quote below is pretty descriptive of your problem

    ankur_libra (9/21/2011)


    On enabling AWE however I got error

    "Address Windowing Extensions (AWE) requires the 'lock pages in memory' privilege which...

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

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

  • RE: copy files through network to another server

    If you dont already have a 3rd party backup product i would install the 2 week trial version of either LiteSpeed or SQLBackup and use this to compress the backups...

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

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

  • RE: Mirroring problem

    rdavies 35008 (9/21/2011)


    Do you think the principal freezes when it disconnects/reconnects from the mirror?

    Hard to say as i have not seen the system. When the mirror reconnects the databases will...

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

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

  • RE: Mirroring problem

    rdavies 35008 (9/21/2011)


    If the mirror is down then I believe the principal will just build up the transactions until the mirror comes back.

    That is correct.

    rdavies 35008 (9/21/2011)


    What I don't understand...

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

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

  • RE: Mirroring problem

    the mirroring scenario you are using requires a 2 phase commit process. A transaction occurs on the principal and is then written to the mirror. The transaction does not commit...

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

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

  • RE: AWE Enabled but no gains in Memory Usage by SQL Server- Requesting Help

    ankur_libra (9/21/2011)


    Hi Perry,

    So you mean to say, that in Boot.ini file:-

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

    [boot loader]

    default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS /PAE - ONLY HERE /PAE IS REQUIRED

    if you have no DEP...

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

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

  • RE: log shipping doesnt work properly

    i log ship from a server in the UK to a server in USA with a time difference of 8 hours. As George says, what exactly is not working?

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

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

  • RE: AWE Enabled but no gains in Memory Usage by SQL Server- Requesting Help

    ankur_libra (9/21/2011)


    [boot loader]

    default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS /PAE

    timeout=30

    [operating systems]

    multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /sos /bootlog /noexecute=optout /fastdetect /PAE

    multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="HP SMP Preserved:Windows Server 2003, Enterprise" /sos /bootlog /noexecute=optout /fastdetect /PAE

    multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="HP SMP Preserved:Windows Server 2003, Enterprise" /noexecute=optout...

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

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

  • RE: How to test Failover in production sql server cluster?

    forsqlserver (9/20/2011)


    But stopping a sql service is a failover ?

    1.Why stopping a cluster service is not comes under failovers test?

    2.May I know all the possible ways to test a failover.

    At...

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

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

Viewing 15 posts - 6,556 through 6,570 (of 9,241 total)