transaction log files clear

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Nagarajanmis
    New Member
    • Jan 2007
    • 2
    #1

    transaction log files clear

    hi,

    Iam using MS SQL Server 2000 . My database transaction log files is too large. I woul like to be clear the log file. If any one suggest me how to that.

    Do you have a sql query to do that steps.

    I was done following things , but no posttive result
    1.tried change a mode FULL to Simple.
    2.Execute BACKUP LOG databasename WITH TRUNCATE_ONLY

    Waiting for your reply .Your action kindly appreciate.

    Thanks for your help.

    Regards
    Nagarajan
    Last edited by Nagarajanmis; Jan 25 '07, 06:59 AM. Reason: Extra info.
    Tags: None
    • shubhangi
      New Member
      • Sep 2006
      • 24
      #2
      Originally posted by Nagarajanmis
      hi,

      Iam using MS SQL Server 2000 . My database transaction log files is too large. I woul like to be clear the log file. If any one suggest me how to that.

      Do you have a sql query to do that steps.

      I was done following things , but no posttive result
      1.tried change a mode FULL to Simple.
      2.Execute BACKUP LOG databasename WITH TRUNCATE_ONLY

      Waiting for your reply .Your action kindly appreciate.

      Thanks for your help.

      Regards
      Nagarajan

      Hi,

      Try following steps
      1. change mode from FULL to Simple.
      2. Right-click the DB & in shrink option, shrink only log files.
      3. revert the mode to Full.

      You will certainly see lot of difference in size of log files.

      Shubhangi

        Comment

        • Nagarajanmis
          New Member
          • Jan 2007
          • 2
          #3
          Originally posted by shubhangi
          Hi,

          Try following steps
          1. change mode from FULL to Simple.
          2. Right-click the DB & in shrink option, shrink only log files.
          3. revert the mode to Full.

          You will certainly see lot of difference in size of log files.

          Shubhangi
          hi,

          Thanks for your mail,

          I got the query solution from my frined. It's worke it out fine.

          Any way thanks for your replay and your assistance.

          Regards
          Nagarajan

            Comment

            Previous template Next
            Working...