Forum Replies Created

Viewing 15 posts - 6,421 through 6,435 (of 9,244 total)

  • RE: Failover Cluster - Add node

    derekr 43208 (10/11/2011)


    does running the "add node" install SQL Server.

    Thanks

    That's exactly what it does. As i mentioned previously, ensure the node is added to the Windows cluster first and any...

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

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

  • RE: Logshipping errors report incorrect data

    please post the results of the following query, executed against the primary server

    exec sp_help_log_shipping_primary_database @database = 'your primarydb'

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

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

  • RE: Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2

    mohammed moinudheen (10/11/2011)


    But I have a question. Initially, as I couldn't see the adapters I had configured the Microsoft Loopback Adapter and assigned the static IP addresses. Please let me...

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

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

  • RE: Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2

    Try installing the VMWare tools in each of the windows virtual machines, this could be why you don't see the adapters.

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

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

  • RE: Best practices for granular access to production databases for non-DBA users

    What horrifies me is that general users are able to backup and retrieve the companies data :w00t:

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

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

  • RE: How To restore/attach DB with alternate mdf file (holds indexes only)

    YSLGuru (10/10/2011)


    I guess what I don't understand about this is that because the file does not contain any data, just index information then I would think you could do something...

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

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

  • RE: Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2

    mohammed moinudheen (10/10/2011)


    Due to some reason, I was not able to view any network in ClusterDC,Node1 or Node2 VMs.

    not sure what you mean by this.When you login to the...

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

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

  • RE: Best practices for granular access to production databases for non-DBA users

    sounds very much like you need an on call DBA!

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

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

  • RE: What options are out there when Prod SQL Network and Standby SQL Network names are different and you need to failover quickly

    Patti Johnson (10/10/2011)


    Hey Perry, since the IP address doesn't change does that mean I would have to reconfiure mirroring and anything else that I have configured that uses the host...

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

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

  • RE: SQL server back up

    i suspect it may someone who works for the company πŸ˜‰

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

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

  • RE: Partitions

    MysteryJimbo (10/10/2011)


    1,000 only equates to approx 3 years of a daily partition. A long time if youre partitioning in months though! πŸ˜€

    agreed, it all depends on the definition...

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

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

  • RE: Partitions

    good catch, worth pointing out that 1000 is still the standard theoretical out of the box though.

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

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

  • RE: SQL Server undocumented commands

    Dev @ +91 973 913 6683 (10/10/2011)


    Has anyone burnt his hands in such practice?

    No, because we test new CUs or SPs and check what effect they have on the...

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

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

  • RE: SQL Server undocumented commands

    Dev @ +91 973 913 6683 (10/10/2011)


    What about the existing implementations?

    That's exactly what I am referring too!!

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

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

  • RE: SQL Server undocumented commands

    Dev @ +91 973 913 6683 (10/10/2011)


    Perry Whittle (10/10/2011)


    they may change at any point

    Isn’t it a reason to worry?

    no, as Microsoft advise hwne using any of these procedures be...

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

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

Viewing 15 posts - 6,421 through 6,435 (of 9,244 total)