Sakthivel Chidambaram (2/2/2009)
Hi,Anyway you are going to configure log shipping which is already a DR then why again Full backup to DR location?
May be you can take full backup at local location and move it to tape and ship the tape to DR location which is what normal practice....
Thanks for your suggestion. But actually my situation is like this.. I need to take full backups and TL backups daily in my production environment (not to the DR location), and it is often requred for restores.
Apart from this, we have a DR location, where the latest copy of production instance needs to be there incase the production goes down. For this when we configure log shipping, it contradicts with the backup plan in the production server. Thats the problem. 🙁