4 Replies Latest reply on Apr 1, 2009 12:51 AM by Tor Iveroth

Can i delete the transection log

Idspl Support Mar 4, 2009 10:19 AM

Hi Forum

there is a problem with sql server. problem is can i delete the transection log as my database crossing the 55GB .

Here i mention transection log which contain all the history of every document. i needed only the previous 1 months info.

Can i delete the transection log

Idspl Support Mar 7, 2009 3:41 AM (in response to Idspl Support)

any suggesion will be apppriciated
Like Show 0 Likes(0)

Actions
- Can i delete the transection log
  
  1-A5CHD1 Mar 7, 2009 5:12 AM (in response to Idspl Support)
  
  Try shrinking it first.
  
  Like Show 0 Likes(0)
  
  Actions
  - Can i delete the transection log
    
    Idspl Support Mar 7, 2009 7:45 AM (in response to 1-A5CHD1)
    
    Thanks lee for ur suggestion.
    
    But shrinking only compress the transection log. For me There is no need of data that are older than one month.
    
    Can i fix a schedule that delete the transection log which are older than one month?
    
    Like Show 0 Likes(0)
    
    Actions
    - Can i delete the transection log
      
      Tor Iveroth Apr 1, 2009 12:51 AM (in response to Idspl Support)
      
      I suggest you ensure the database is set to "simple recovery model" before you shrink the transaction log. Otherwise it might not do much good. Have a look in the install guide, chapter "managing the SQL transaction log size". It should then shrink automatically upon each backup.
      
      Regards
      Tor iveroth
      Principal PDM Technical Support and Implementation Engineer
      Dassault Systèmes SolidWorks Corp.
      
      Like Show 0 Likes(0)
      
      Actions

Go to original post