Forum Replies Created

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

  • RE: restore log backups to another server

    mah_j (10/9/2012)


    yes exactly as you said.

    So how can you state that the servers "cant see" each other.

    The access you are describing requires Netbios ports to be opened!!!

    If you can...

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

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

  • RE: What is a read ?

    SQLSACT (10/8/2012)


    Is it safe to say that when a page is requested and it's not in the buffer pool, 2 reads are happening, 1 Physical(To bring the page into memory)...

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

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

  • RE: restore log backups to another server

    mah_j (10/8/2012)


    i use map network to see the drive on server A to have the backup files

    The way i am understanding what you have said above is that on server...

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

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

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

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