I have a .LDF (log) file that has grown to 5GB.

Could you recommend a safe procedure to complete the
following?
1) Backup up Timeport_log.LDF
2) Remove all data from Timeport_log.LDF so that only
one or more days of log information is contained in this
file.

Could you provide recommendations on developing a
scheduled process that keeps this .LDF file down
to a small size?

Thanks,
Jack

Jack,
While this is not at related to SQL Full-text Search (FTS), you should
review these KB articles:
272318 (Q272318) INF: Shrinking the Transaction Log in SQL Server 2000 with
DBCC SHRINKFILE
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/Articles/q272/3/18.asp&NoWebContent=1

and for SQL Server 7.0:

256650 (Q256650) INF: How to Shrink the SQL Server 7.0 Transaction Log
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/Articles/q256/6/50.asp&NoWebContent=1

You might also want to review this Microsoft Support WebCast:
Microsoft SQL Server 7.0 common problems and resolutions
http://support.microsoft.com/default.aspx?scid=%2Fservicedesks%2Fwebcasts%2Fen%2Fwc082900%2Fwct082900.asp

see more support Webcasts at
http://support.microsoft.com/default.aspx?scid=fh;RID;webcst&style=type2&sd=gn


Regards,
John
PS: SQL Server version and OS Platform info via SELECT @@version is always
helpful info to provide when you post questions.





[quoted text, click to view]