May 5, 2003 at 11:21 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.
Can I Log ship to two backup database servers from production server?
Edited by - ht2k on 05/05/2003 11:23:28 AM
May 5, 2003 at 11:39 am
You can't use the built in log shipping wizard to do that in SQL Server but you can create your own log shipping solution to constantly copy database and log backups from PROD server to your second server and restore the backups without recovery.
May 5, 2003 at 1:24 pm
thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply