SQL Server Performance Forum – Threads Archive

Transaction Log free space

Hi, you all. How i can free space in my transaction log, I made a log backup with "Remove inactive entries from transaction log" but it doesn’t work, also I tried shrink the DB. MSSQL 2000. Thanks.
Ing. Alejandro Duran

---

Referhttp://sql-server-performance.com/forum/topic.asp?TOPIC_ID=768 Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

---

Try DBCC SHRINKFILE. Bambola.

---

If none of the above suggestions work, you can detach the database with sp_detach_db, delete or rename the log file and re-attach the database using sp_attach_single_file_db. This will create a new log file with small size.

---

OK sp_detach_db option fix the issue. but I used the visual interface of 2000.
THX . Ing. Alejandro Duran

---

]]>