AnsweredAssumed Answered

Can i delete the transection log

Question asked by IDSPL Support on Mar 4, 2009
Latest reply on Apr 1, 2009 by Tor Iveroth

Like • Show 0 Likes0
Comment • 4

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.

No one else has this question

Outcomes

4 Replies

IDSPL Support Mar 7, 2009 3:41 AM
Mark Correct
Correct Answer
any suggesion will be apppriciated
Like • Show 0 Likes0
Actions
- 1-A5CHD1 @ IDSPL Support on Mar 7, 2009 5:12 AM
  Mark Correct
  Correct Answer
  Try shrinking it first.
  Like • Show 0 Likes0
  Actions
  - IDSPL Support @ 1-A5CHD1 on Mar 7, 2009 7:45 AM
    Mark Correct
    Correct Answer
    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 Likes0
    Actions
    - Tor Iveroth @ IDSPL Support on Apr 1, 2009 12:51 AM
      Mark Correct
      Correct Answer
      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 Likes0
      Actions

Can i delete the transection log

Outcomes

Related Content

Recommended Content