Forum Replies Created

Viewing 15 posts - 6,316 through 6,330 (of 9,241 total)

  • RE: Failover Cluster - Add node

    hmm, you should always uninstall the clustered applications if possible before evicting the node. I would go for a clean install and then re introduce the node and re install...

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

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

  • RE: Cluster Adding Evicted Node

    see my response to your previous post 😉

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

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

  • RE: Failover Cluster - Add node

    if the node was previously a member and was evicted cleanly then there shouldnt be any reason why you cant re introduce the server, although i always prefer a clean...

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

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

  • RE: uninstall reporting services on a clustered instance

    carefully run through the change setup paying attention to the options offered, it should become fairly obvious 😉

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

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

  • RE: uninstall reporting services on a clustered instance

    no, not the active node because SSRS is not cluster aware. Go to Add\Remove programs on the node where you want to uninstall the instance and select Change.

    During setup you...

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

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

  • RE: uninstall reporting services on a clustered instance

    itsamarnath (10/25/2011)


    We have a 2 node cluster with 2 instances running.

    Both the instances are configured for reporting services.

    Now, the client wants us to uninstall reporting services from one of this...

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

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

  • RE: LogShipping_Copy fail

    check the share permissions as well as the NTFS permissions. A share defaults to Everyone - Read!

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

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

  • RE: Cluster Administrator

    SVR (10/24/2011)


    Hi,

    I do not have cluster administrator installed. How to get it installed on my laptop?

    check out my 3 part guide on this site at this...

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

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

  • RE: How do I decide which column(s), if any, I should place my clustered index on?

    tell them its not preaching its fact!

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

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

  • RE: How do I decide which column(s), if any, I should place my clustered index on?

    jared-709193 (10/24/2011)


    Yes, their view definition included the TOP and ORDER BY

    don't know how many times it's been said but "Don't order by in a view" 🙂

    A view is essentially...

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

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

  • RE: Testing to see if a database is still being used

    i pasted but it did nuttink. have corrected it now 😉

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

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

  • RE: Testing to see if a database is still being used

    Rod at work (10/24/2011)


    OK, simple question here, but I need to ask it. I was under what must be a mistaken thought that traces could run only against 1...

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

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

  • RE: How do I decide which column(s), if any, I should place my clustered index on?

    jared-709193 (10/24/2011)


    This is a SELECT ... from a view in which they used a TOP and ORDER BY.

    are you saying the view definition is created upon a select statement...

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

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

  • RE: Testing to see if a database is still being used

    don't forget to set the rollover option too, by default it scripts out to zero which means no file rollover. This puppy catches a lot of people out. Also be...

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

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

  • RE: Testing to see if a database is still being used

    if you're unsure, use a server side trace for a week or so to monitor user connections before decommissioning

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

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

Viewing 15 posts - 6,316 through 6,330 (of 9,241 total)