Forum Replies Created

Viewing 15 posts - 4,846 through 4,860 (of 9,241 total)

  • RE: SQL Server on Domain Controller

    Quite right, SBS runs Exchange, SQL server, IIS and domain controller. Its mainly about performance, which is why the min spec for an SBS server is so high for such...

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

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

  • RE: What is a read ?

    Jeff Moden (10/8/2012)


    CYates (10/8/2012)


    I've always gone by Microsoft's explanation:

    ...

    {snip}

    Also, keep in mind that when you run a trace it is considered a logical read and not physical.

    Have you got an...

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

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

  • RE: DB Mirroring High Safety Mode wihtout witness

    Sure, no problem

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

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

  • RE: DB Mirroring High Safety Mode wihtout witness

    DBA_Learner (10/8/2012)


    I am thinking of these steps to determine. Please correct if there is any mistake. Thanks

    1)If Primary Server Fails, then on Mirror Server execute

    ALTER DATABASE <database_name> SET PARTNER...

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

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

  • RE: DB Mirroring High Safety Mode wihtout witness

    Books Online just being cautious then:-D

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

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

  • RE: Ryder Cup 2012

    Lessons from a pro

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

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

  • RE: DB Mirroring High Safety Mode wihtout witness

    you would have thought so Gail, but BOL still states that forced service is possible with safety on and no witness but at the risk of possible data loss. In...

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

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

  • RE: DB Mirroring High Safety Mode wihtout witness

    DBA_Learner (10/8/2012)


    Thanks Gila, That's good steps what you have given. So last question is When the principal is ready, do we need to do any backup on mirror server...

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

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

  • RE: DB Mirroring High Safety Mode wihtout witness

    Ah right I see now i have re read thoroughly and i made an error in my post. If Server A fails you cannot failover you must force service using...

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

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

  • RE: DB Mirroring High Safety Mode wihtout witness

    incorrect and misleading info removed, didnt read thorughly, please see below

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

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

  • RE: Changing Locations of DataFile

    No work as I have it documented myself already 😉

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

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

  • RE: Changing Locations of DataFile

    runal_jagtap (10/8/2012)


    Hey Perry can you just attach step by step processs which u did... so that while doing it at my end i wont miss any step..

    Yes I can, but...

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

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

  • RE: Sensible values for Database Mirroring Monitor Threshold

    Kwisatz78 (10/8/2012)


    Hi all

    As the title suggests I am wondering what other people are using as thresholds for database mirroing. We have a multi-site mirror which is connected by fibre...

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

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

  • RE: Ryder Cup 2012

    I'm still learning at the mo, got myself a nice set of second hand Ping Eye 2 irons and Callaway ERC Fusion woods 🙂

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

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

  • RE: Changing Locations of DataFile

    runal_jagtap (10/7/2012)


    Hi Perry Whittle,

    Did you goyt any chance to perform this at your end???:-)

    I am still waiting for the approval :w00t:

    Hi, yes my tasks around this have been completed. What...

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

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

Viewing 15 posts - 4,846 through 4,860 (of 9,241 total)