>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
This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4