Perry Whittle (4/21/2014)
Why not just use log shipping, seems it would be perfect for this scenario.
Thanks for your comment Perry.
You are absolutely right. Log shipping is also a very good option.
However, in our case we went ahead with this script because,
1. Using this method, we were able to refresh the other server without doing any major change\configuration on Production.
2. There might be few databases which were in Simple Recovery Model & hence log-shipping was not a viable option for them.
3. Using this script required less maintenance.