you have two options one is Database mirroring and other is log shipping in sql 2005..........but i advise you to go with db mirroring as the downtime is less in high availability mode as you have a witness server and hence the failover will be automatic and within few seconds............but in log shipping only manual failover is possible........refer,
http://dumthata.com/sqlchn/articles/dbmrr.htm
http://dumthata.com/sqlchn/articles/lship.htm
Going forward pls post in the appropriate forum as it would be easier to read through and answer....
No comments:
Post a Comment