House of Fusion
Search over 2,500 ColdFusion resources here
  
Home of the ColdFusion Community

Mailing Lists
Home /  Groups /  ColdFusion Talk (CF-Talk)

how to free up some log space in SQL server 2000?

  << Previous Post |  RSS |  Sort Oldest First |  Sort Latest First |  Subscribe to this Group Next >> 
Top  |   Reply  |   Original Post  |   RSS Feed  |   Subscribe to this Group
Author:
John Ho
07/28/2003 09:53 AM

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

Top  |   Parent  |   Reply  |   Original Post  |   RSS Feed  |   Subscribe to this Group
Author:
John Ho
07/28/2003 01:35 PM

thanks Alex John

Top  |   Reply  |   Original Post  |   RSS Feed  |   Subscribe to this Group
Author:
A.Little
07/28/2003 10:36 AM

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 ----- Excess quoted text cut - see Original Post for more -----

Top  |   Parent  |   Reply  |   Original Post  |   RSS Feed  |   Subscribe to this Group

<< Previous Thread Today's Threads Next Thread >>

Search cf-talk

October 25, 2014

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
       1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31   

Designer, Developer and mobile workflow conference