Forum Replies Created

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

  • RE: Removal of a node from Cluster

    what service pack is the live instance currently at?

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

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

  • RE: Remove reporting services from a clustered instance

    i've already answered this in your duplicate post 😉

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

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

  • RE: Failed to give alret when Restore not happened from last 5 hours in Logshipping

    when you configure log shipping the alert jobs are created for you.

    Please post the full results of the following executed against your secondary instance

    sp_help_log_shipping_monitor_secondary

    @secondary_server = 'secondary_server',

    @secondary_database = 'secondary_database'

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

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

  • 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" 😉

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