Do a backup of the transaction log, and under the 'options' tab in SQL Ent. Manager select the 'remove inactive entries from transaction log' option.
You'll probably want to have the transaction log backed up regularly (at least daily) - so when you do the transaction log backup, also select the option to schedule the job. These might be of some help... http://www.sqlteam.com/FilterTopics.asp?TopicID=115 http://www.sqlteam.com/FilterTopics.asp?TopicID=116 HTH, Alex > -----Original Message----- > From: John Ho [mailto:[EMAIL PROTECTED] > Sent: 28 July 2003 14:51 > To: CF-Talk > Subject: how to free up some log space in SQL server 2000? > > > hi all > My log file is full. And I need to free some space > in log file. Could you please show me how to do it? > > Thanks > John > > __________________________________ > Do you Yahoo!? > Yahoo! Calendar - Free online calendar with sync to Outlook(TM). > http://calendar.yahoo.com > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4