SQL Server Performance Forum – Threads Archive
Transaction Log free spaceHi, 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
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