Logshipping or replication are not HA or DR solutions. these two features has a their limitations. You did not mention abt your current environment and SQL SERVER editions etc. Why...

Hi

We are on SQL Server 2008 R2 Ent with SP1 . If you are on RTM , its a good idea to get upto CU5 or above.

Cheers

Murali

What is the SQL Server Version you are running on

Hi Kevin

Thanks for the update. Do you have suggestions to automate this process.

Thanks in advance.

Cheers

Murali

Thanks a lot for your time and suggestions.

1. We need nearly upto-date data with live DB.

2. With regard to the replication , lot of the tables donot have any...