Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2003-09-01 : 02:27:45
|
| Hi,Here goes another Q for Log Shipping . We have two production servers and one DR server . We need to have one day previous data on the DR SQL server as part of our company's ploicy . Now recently our DR SQL server was rebuilt with a clean installation of SQL Server Enterprise Edition ( Same as Production ) . My plan for the DR site now is to set up transactional replication ( rather than Log shipping ) after i restore all the databases on the DR SQL server . Then all the consecutive changes will be reflected through the transactional replication every day as per schedule. I am really not sure how Log Shipping will help me in this case and would like to have your suggestions and comments . I know that LS is a high availaibility plan but can transaction replication offer me the same. Finally we all know that the databases on a Disaster recovery server will never be up-to-date with the production servers . Thanks. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-09-01 : 14:24:29
|
| Log shipping restores tr log periodically to a standby database. Transactional replication get the data across faster and does not require the database to remain in standby.log shipping is simple (especially if you implement it yourself rather than use microsofts).Replication is a lot more complicated to administer.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Log Shipping - recommended ????