Forum Replies Created

Viewing 8 posts - 31 through 38 (of 38 total)

  • RE: 1 DB and 2 Servers

    GilaMonster (7/28/2011)


    ajsnyman (7/28/2011)


    I like that the 2nd DB can be used as a reporting server 🙂

    If you do that, the second server must be licensed.

    Cool, thanks 🙂

  • RE: 1 DB and 2 Servers

    MysteryJimbo (7/28/2011)


    Except in servers under extreme load the performance hit caused by mirroring is negligable. Data loss can be zero with syncronous mode.

    Thank you.

    I like that the 2nd DB...

  • RE: 1 DB and 2 Servers

    steveb. (7/28/2011)


    ajsnyman (7/28/2011)


    steveb. (7/28/2011)


    ajsnyman (7/28/2011)


    steveb. (7/28/2011)


    ajsnyman (7/28/2011)


    Each server will have its own SQL instance, but only one SQL instance will have the DB attached.

    So when the primary...

  • RE: 1 DB and 2 Servers

    steveb. (7/28/2011)


    ajsnyman (7/28/2011)


    steveb. (7/28/2011)


    ajsnyman (7/28/2011)


    Each server will have its own SQL instance, but only one SQL instance will have the DB attached.

    So when the primary server dies, so...

  • RE: 1 DB and 2 Servers

    steveb. (7/28/2011)


    ajsnyman (7/28/2011)


    Each server will have its own SQL instance, but only one SQL instance will have the DB attached.

    So when the primary server dies, so we can just...

  • RE: 1 DB and 2 Servers

    Jayanth_Kurup (7/28/2011)


    Why not database mirroring ? its a high availability solution with automatic fail over ? i think it would work better for you than having to manually fail...

  • RE: 1 DB and 2 Servers

    Each server will have its own SQL instance, but only one SQL instance will have the DB attached.

    So when the primary server dies, so we can just attach the DB...

  • RE: 1 DB and 2 Servers

    The DAS enable each server to access the DB as if it was on a harddrive in the server it self.

    Thus sharing the same data 🙂

Viewing 8 posts - 31 through 38 (of 38 total)