Forum Replies Created

Viewing 15 posts - 3,016 through 3,030 (of 9,244 total)

  • RE: Database Mirroring Suspended - OS error 3 Reason 15105

    DBANewbie (7/9/2013)


    I can resolve this by dropping and recreating the mirroring session

    And that's exactly what Books Online tells you to do 😉

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

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

  • RE: Setting up AG on default and named instance

    I'm assuming this is your configuration

    ServerA ...

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

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

  • RE: SQL Server 2008 R2 Question

    Koen Verbeeck (8/27/2014)


    but they already have the hardware...

    There would still usually be a nominal cost to cover hardware, maintenance and OS licensing

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

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

  • RE: SQL Server 2008 R2 Question

    there will undoubtedly be a cost which your dept may be expected to fund

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

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

  • RE: Virtual Backups

    rstone (8/26/2014)


    It would be nice to restore a db - or server - from a snapshot then apply diff and log backups to a point in time. If this...

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

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

  • RE: Log shipping between different domain, need help

    Check my guide at this link[/url]. It details machines in a workgroup but is also relevant to different domains too

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

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

  • RE: Setting up AG on default and named instance

    muthyala_51 (8/26/2014)


    plan to setup AG on in both default and named instance of two nodes. Can we do it ? any suggestions ?

    yes you can, each instance must be on...

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

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

  • RE: Migrating sql instances from old 2012 cluster to new 2012 cluster

    The links below detail how to change the IP and network name, you will of course have to ensure the resources are offline on the old cluster first.

    http://msdn.microsoft.com/en-us/library/ms178083.aspx

    http://msdn.microsoft.com/en-us/library/ms190460.aspx

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

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

  • RE: service accounts for active/passive cluster

    its still not clear and doesn't make complete sense. you can only have 1 default instance in the cluster the rest must be named.

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

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

  • RE: Migratioon or Upgradaion

    ramana3327 (8/26/2014)


    First we have to run the upgrade adviser to know the potential issues.

    Yes, this is a basic requirement, you want to know where compatibility issues will lie.

    ramana3327 (8/26/2014)


    Then we...

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

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

  • RE: service accounts for active/passive cluster

    doesn't make sense can you explain in more detail please

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

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

  • RE: date still showing up as YYYY-MM-DD

    what are the Windows regional settings on the server set to

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

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

  • RE: Large network packet size

    packet size can be set at the client level also

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

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

  • RE: Importing Excel table into existing table

    cbernardes (8/25/2014)


    When I go through the wizard, it does not allow me to chance the Source Type for my Source Column.

    That's because they're set in excel, you'll need to tell...

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

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

  • RE: date still showing up as YYYY-MM-DD

    Please post the result of this query

    select configuration_id, value

    from sys.configurations

    where configuration_id = 124

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

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

Viewing 15 posts - 3,016 through 3,030 (of 9,244 total)