we dont want log growing for deleting the records without affecting DB Mirror,how to handle this ONE?
Minimal logging is not a possibility, because deletes can't be minimally logged and even if they could mirroring requires full recovery model.
The usual method is to delete in chunks and do transaction log backups between each chunk. It'll still use the same amount of log but the log backups mark the log reusable between each delete chunk.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass