May 5, 2003 at 11:24 am
I am currently running log shipping from production server (SQL_prod) to backup database server (SQL1 (standby)). It has set up for nightly full backup and every 5 minutes transaction log backuped on SQL_Prod and log shipped to SQL1 every five minutes and restored with delay of 2 minutes on SQL1. I need to have similar set up for another backup database server (SQL2 (Standby)). Need to set up log shipping from any of the servers (SQL1) or (SQL_Prod), so data stays in synch. Need suggestions. Goal is to keep production server in synch with SQL1 and SQL2 server, which can be used as a production in case of failover.
May 6, 2003 at 4:14 am
Duplicate post, please keep messages in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=11920&FORUM_ID=7&CAT_ID=1&Topic_Title=Log+shipping+to+Two+backup+servers&Forum_Title=Replication
Moderator please lock or remove this post.
May 6, 2003 at 9:38 pm
Thanks.
I was trying to delete the post but it does not have feature to delete your own post.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply