Arun (2/2/2009)
For this when we configure log shipping, it contradicts with the backup plan in the production server. Thats the problem. 🙁
Why? There shouldn't be any problem. Take full backups daily and write them to tape, set up the log shipping so that it doesn't delete the tran log backups after they've been shipped, and then you can write them to tape.
I don't understand the problem that you seem to have.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability