balamurugan.devadas (6/17/2013)
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.
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