SQL Server Performance Forum – Threads Archive

Expiration Policy

I have setup txn log backups with a 2 day expiry policy. Unfortunately i dont see the txn logs getting over-written after 2 days on the backup device? Am I missing something? Appreciated any help on this. Thanks,
Cali

---

What is the service pack level on SQL Server?
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

---

Thanks for your answer. The service pack runing on SQL Server is Sp1.

---

Trie with SP2 on SQL 2005? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

---

]]>