August 4, 2010 at 8:36 am
not to sure I completely understand.
you have server A and log shipping to B & C, so you had 2 standby servers.
I am guess there is no problem with that?
August 4, 2010 at 8:55 am
No not exactly,
I got server A and B.
Server A is the primary database server. Server B is the secundary database server.
On server B, I have 2 databases which are Standby/Read-only and are logshipped from a database located on Server A.
August 4, 2010 at 9:15 am
If you look at the restore job on the target server, how is it configured? Are there parameters that list both databases?
If so, you can potentially just setup your own second job to do this.
If not, there might not be a way to change the built in log shipping. However you could write your own script, or find some here, that help you do the log shipping yourself. It's not a complicated process. A little scripting to move files is really what it is.
http://www.sqlservercentral.com/articles/Administration/customlogshipping/1201/
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply