SQL Server Performance

Log shipping more databases

Discussion in 'SQL Server Log Shipping' started by fasttrack, Oct 11, 2006.

  1. fasttrack New Member

    Hi,

    I am building a solution with Log Shipping (replication, clustering, NLB etc in this context are not applicable).

    My question is:

    Log shipping must be applied on 3 different Database; It is better to build a log shipping for every DB (so 3 log shippings), or one Log shipping for the 3 DBs.
    In my experience I worked ony with a DB, but now I need to copy 3 databases.

    I supposed it is better 3 log shippings, but starting the configuation I have found that more than 1 db is possible to select, so the question arises.


    Thank for your useful suggestions

  2. hshapiro New Member

    We do log shipping on 4 databases. I have found that 4 different log shipping procedures work better. That way, if I need to stop logshipping on 1 database, the others are not affected.
  3. fasttrack New Member


    OK, thank for your reply,

    About the possibility to select more than db is that is not possible, just tried! just to test if possible.


    Thank
  4. satya Moderator

    I would suggest to keep individual LS plans for each database, for maintenace purpose.
    At the end the process is following using maintenance plans, so if you want to stop for a particular database then you can choose so.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  5. techbabu303 New Member

    does log shipping move all the data across which are modified or everything after first time it has run ?
  6. satya Moderator

    Only user databases and not system databases [<img src='/community/emoticons/emotion-1.gif' alt=':)' />].<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
  7. ccadmin New Member

    quote:Originally posted by fasttrack

    Hi,

    I am building a solution with Log Shipping (replication, clustering, NLB etc in this context are not applicable).

    My question is:

    Log shipping must be applied on 3 different Database; It is better to build a log shipping for every DB (so 3 log shippings), or one Log shipping for the 3 DBs.
    In my experience I worked ony with a DB, but now I need to copy 3 databases.

    I supposed it is better 3 log shippings, but starting the configuation I have found that more than 1 db is possible to select, so the question arises.


    Thank for your useful suggestions


  8. ccadmin New Member

    hi,satya & fasttrack:
    I am getting similar problem.I need to log shipping 3 USER databases.
    how can I do£¿

    Thank for your suggestions
  9. satya Moderator

Share This Page