Forum Replies Created

Viewing 15 posts - 7,681 through 7,695 (of 9,241 total)

  • RE: Upgraded SQL 2005 Cluster to 2008 R2, Cluster Resource FullText fails to start

    are there any other more meaningful errors in the event log?

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

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

  • RE: Log and Data placement on a SAN.

    Andeavour (9/1/2010)


    So it can also depend on what you are calling a SAN...:crazy:

    very true. I too have experience of Netapp filers and as you say if the disks are configured...

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

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

  • RE: Log and Data placement on a SAN.

    Is it not possible for you to reconfigure the disks at this stage?

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

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

  • RE: Do we need to set the preferred node?

    I always set it, but only really required if you intend to configure\use failback policies!

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

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

  • RE: Convert Decimal to Varchar (or Vice Versa)

    yes, that too! 😉

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

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

  • RE: sql server architecture

    Jeff Moden (8/29/2010)


    "How does the engine on my car make it go?".

    🙂 Lets not start discussing the 4 stroke engine here!

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

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

  • RE: SP1 is unable to extract files itself in Single node Cluster on Windows 2008

    gmamata7 (8/28/2010)


    Here is the solution:

    Extract the SP1 files to a temporary folder and then install SP1 from there.

    Thanks

    Extract the SP1 files to a temporary folder on the C drive and...

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

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

  • RE: SQL2008R2 on Windows2008R2 or 2003R2

    There's a whole host of reasons why, remember that Windows 2003 SP2 is the minimum supported OS to cluster SQL server 2008. If management are happy opting for minimum spec...

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

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

  • RE: Convert Decimal to Varchar (or Vice Versa)

    This should work for you

    ON CAST(a.BAN as varchar(??)) = s.BAN

    where ?? is the varchar length!

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

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

  • RE: SQL Farms

    TRACEY-320982 (8/29/2010)


    Anyone know if there is software that is for SQL Farms. Almost like Citrix has it own farm and vm farms. Is there actual SQL Farm software?

    We...

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

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

  • RE: 2008 Enterprise vs 2008 Standard

    costs for 3rd party backup software are not that excessive. I prefer the rigidity that SQLBackup offers rather than using native backup compression

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

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

  • RE: Log Shipping vs Failover clustering vs Mirroring vs Transactionnal (peer-to peer)Replication

    Andrew Fowler-367854 (8/26/2010)


    Perry, even using .net your failover might not be seamless if you are using connection pooling. Atleast that has been my experience.

    good point!

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

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

  • RE: Problem with installing SP3 on SQL server 2005 Failover Cluster

    Don't pause any nodes, install SP3 from the active node.

    Incidentally what version are you upgrading from?

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

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

  • RE: Database Mirroring - Web App question

    Depends on what you are trying to achieve. Thinking about it a little more you could have a copy of the web on the mirror and make the website live...

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

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

  • RE: Database Mirroring - Web App question

    jody 26314 (8/26/2010)


    OR do i need to have the webapp on a different server than LIV and MIR?

    Yes!!

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

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

Viewing 15 posts - 7,681 through 7,695 (of 9,241 total)