Post reply

Logshipping

  • August 14, 2009 at 9:12 am

    #134771

    Hi,I have a question:

    I have two primary databases Testdb and Trackdb for logshiping and i have two servers available acting as primary server and secondary/destination server.Can i put both databases separartly on both servers and can use both servers as primary for each other and secondary for each other as well?

    Like:

    ServerA.Testdb--------------->ServerBTestdb

    ServerA.Trackdb<----------------ServerBTrackdb Here ServerA is primary server and ServerB is secondary server for Testdb database and for Trackdb database serverB is primary server and ServerA is secondary server.
    Also what about monitoring server?should i use third server as monitoring server or i can use these both servers as monitoring servers for each other?

    Thanks Irfan

  • August 14, 2009 at 9:23 am

    #1039455

    Hi Irfan

    YES you can do this on Logshipping

  • August 14, 2009 at 9:26 am

    #1039459

    When you define the log shipping, you define it at a database level and not at a server level. This means that on both servers you can have primary database and secondary databases (as long as those are different databases).

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • August 14, 2009 at 9:38 am

    #1039471

    I am not clear about monitoring server yet but

    Thank you of both of you CrazyMan and Adi for your help.

    Thanks Irfan

  • August 16, 2009 at 5:22 am

    #1039933

    Irfan (8/14/2009)

    I am not clear about monitoring server yet

    You can have a third server a monitoring server that can monitor several log shipping databases.

    Alternatively you can query individual primary and secondary databases for log shipping alerts/history/status etc...


    Pradeep Singh

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply