User Profile

Collapse

Profile Sidebar

Collapse
Nagarajanmis
Nagarajanmis
Last Activity: Feb 5 '07, 06:42 AM
Joined: Jan 25 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Nagarajanmis
    replied to transaction log files clear
    in SQL Server
    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...
    See more | Go to post

      Leave a comment:

    • Nagarajanmis
      started a topic transaction log files clear
      in SQL Server

      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...
      See more | Go to post
      Last edited by Nagarajanmis; Jan 25 '07, 06:59 AM. Reason: Extra info.
      No activity results to display
      Show More
      Working...