SQL Server Performance Forum – Threads Archive

Log shipping more databases

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

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.

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

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.

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

Only user databases and not system databases [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]. <hr noshade size="1">Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing.</center>

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

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

http://www.sql-server-performance.com/articles_clustering_log_shipping.asp
http://www.sql-server-performance.com/sql_server_log_shipping.asp 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.

]]>