Forum Replies Created

Viewing 15 posts - 6,016 through 6,030 (of 9,241 total)

  • RE: Transaction Log file size issue

    rajg (2/6/2012)


    But my problem at this moment is - log file has is very large and recently it created problem. Last friday - it automatically increased the size since autogrowth...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: ignoring duplication on uppercase and lowercase value.. help

    Case sensitivity is not the way to go. Based on the data provided the OP would only be able to insert 2 duplicate records, what if they want to insert...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: ignoring duplication on uppercase and lowercase value.. help

    duplicate

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: ignoring duplication on uppercase and lowercase value.. help

    The PK constraint across the airline_cd column will require unique values. You could drop the PK constraint, but I think you would be better off designing the table and it's...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: How many IP address include in 2 node active -passive cluster

    Shivrudra (1/17/2012)


    Hi,

    How many IP address include in 2 node active -passive cluster .....

    i answered Five ........2 for private network

    ...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: 3GB PAE in windows 2008 32 bit?

    ananda.murugesan (2/4/2012)


    also running other application symantec Endpoint Protection, it is scanning on weekly one time basis, and daily basis LTO Backup running on night time. could you confirm 1GB memory...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Trying to get dev team off the sa account

    SkyBox (1/25/2012)


    coded into VB6

    God that shows how behind the times they are, have you also explained that Ronald Reagan is no longer president πŸ˜€

    SkyBox (1/25/2012)


    It’s a touchy subject because they...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: SQL Server 2005 mirroring

    beejug1983 (2/1/2012)


    Hi,

    Does quorum in Mirroring works as a quorum in Clustering. Please describe how quorum works in mirroring.

    Thanks

    If anything the quorum in database mirroring rather more matches the new clustering...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Move 2005 System DB Files in Clustered Instance

    hayden_jones (1/23/2012)


    What I'm still not clear on is the starting of the instance with the NET START command. Usually, I bring SQL up and down from the Cluster Administrator.

    leave...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: New Cluster: Fail Over Test Breaks Connections

    SQL_Giant (1/31/2012)


    To achieve seemless failover, you would have to implement Database mirroring

    Mirroring does not guarantee to provide seamless failover, in fact, a mirror session can take sometime to failover depending...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Database Mirroring

    yes, it is possible. Are you using the mirroring GUI or T-SQL?

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: huge transaction log file

    sohairzaki (2/4/2012)


    I am using full backup on daily basis.

    The transaction log file is continually growing.

    I read that if i backed up the transaction log say every 15 minutes this will...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: Best practices for File groups in OLTP Database?

    SQLKnowItAll (2/1/2012)


    Each data file resides in its own filegroup.

    That's not the same as multiple files per file group, which if you don't have a need for, leave well alone.

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: SQl Cluster

    vijay82 (1/31/2012)


    It is win 2003 server.

    In that case check the cluster log at the following path

    C:\windows\cluster\cluster.log

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

  • RE: SQl Cluster

    vijay82 (1/30/2012)


    Hi,

    Can any one please let me know where we have to check the following cluster information.

    1).When was the cluster failover was happened and from which NODE it is moved.

    is...

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

    "Ya can't make an omelette without breaking just a few eggs" πŸ˜‰

Viewing 15 posts - 6,016 through 6,030 (of 9,241 total)