August 4, 2010 at 7:48 am
Hello,
I got a question and i hope some one got the answer for me. At this moment i got the following setup:
A SQL 2005 Ent. server, this server is the primary server in a logship configuration with a size of 350GB. The second server is a SQL 2005 Ent. server, this server is the target server. A little while a go i configured the logshipping for both servers. This works fine.
The situation has changed and there is now need for a second standby database. My idea was to add a second database to the existing target database server. This setup works fine, but... they requested to use a different restore schedule for the newest standby database. I found out that when you change the restore frequency for 1 standby database the schedule for the other database changes to. Of course this is logical because there is only 1 copy and 1 restore job within the SQL 2005 Management Studio of the target server.
Is there any possible way to create a second schedule (without the need to use a second server)?
Thanks!
Sjoerd
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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply