October 11, 2006 at 7:52 am
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.
Thank for your useful suggestions
October 11, 2006 at 9:18 am
I think you'll find, in the 'Database Maintenance Plan Wizard' at least that you can only select 1 database for a particular Log Shipping configuration! This is by design and makes perfect sense, otherwise all databases would rely on each other successfully completing before being able to ship another log.
So in my experience the answer to your question is set up 3 separate Log Shipping jobs, 1 for each database.
ll
October 11, 2006 at 9:38 am
In my experience I worked ony with a DB, but now I need to copy 3 databases.
Yes, I supposed it is the right answer, but Starting the configuation I have found that more than 1 db is possible to select, so the question arises.
Any other suggestion or discussion is appreciated.
Thank
October 12, 2006 at 3:47 am
thank for your reply,
About the possibility to select more than db is that is not possible, just tried! just to test if possible.
In any case, different log shipping are the best for separate db management
Thank
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply