Forum Replies Created

Viewing 15 posts - 6,571 through 6,585 (of 9,253 total)

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

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

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

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

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

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

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

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

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

  • RE: Mirroring problem

    Its all detailed in the link i sent you.

    There are 3 possible quorum modes

    Full Quorum.

    This is where both partners and witness are connected

    Witness to partner.

    This is where the...

  • RE: Change the node names of a Windows cluster

    yes it's a lot of work. I did similar to this in my last contract. I had to rebuild all the cluster nodes one at a time and went through...

  • RE: Rebuild master database problem

    just out of interest why are you rebuilding, are you changing server collation?

  • RE: Cluster Failover

    check the cluster.log at the following location for more details

    C:\Windows\cluster

    or

    C:\Winnt\cluster

  • RE: Moving SQL Agent Jobs

    Theres also an SSIS task to do this which works quite well

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

    Which edition of Windows 2003 SP2 are you using?

    Also, could you post the partition details from the boot.ini file on that server too?

Viewing 15 posts - 6,571 through 6,585 (of 9,253 total)