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=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: how to free up some log space in SQL server 2000?
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=subscribeforumid=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
how to free up some log space in SQL server 2000?
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=subscribeforumid=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
how to free up some log space in SQL server 2000?
thanks Alex John ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
