August 25, 2009 at 2:37 am
Hi Everybody,
In my database Transaction log file size is increasing
My manger suggest me delete unwanted T-log files
how can i delete it can any body please suggest me
Regards
kumar
August 25, 2009 at 3:01 am
You want to delete your transaction log file?????
August 25, 2009 at 3:05 am
Please read through this - Managing Transaction Logs[/url]
and don't even consider deleting the log. It's asking for lots of trouble.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 25, 2009 at 3:11 am
Are you a DBA..?
Transation log should not be deleted.
Backup the LOG and Shrink it. Think that's what you need.
Go through the link which Gail has mentioned.
August 25, 2009 at 3:25 am
The way i read this was that you wanted to delete transaction log backups (typically .trn) from your backup directory? is this correct? If so you can use the cleanup task in maintenance plans to do this.
If - like the others thought - you want to delete your actual transaction logs (.ldf) files then follow their advice - dont!!
Edit: After reading the post again it does look like you want to delete your ldf files. Follow the link posted by gail.
August 25, 2009 at 5:45 am
Hi gail,
Thank you for your reply
Deleting T-log file it is not good right
we will shrink the file only
Is it possible to delete T-log file what happed ?
AS per my knowledge t-log file are not deleted only truncated
i not correct plz correct me
Regards
kumar
August 25, 2009 at 5:51 am
If you want to get rid of space, backup the trn files and the space auto. is available, if you feel you need more space then shrink the trn file, but why do you want to delete the file?
Pavan.
August 25, 2009 at 5:58 am
kumar99ms (8/25/2009)
Hi gail,Thank you for your reply
Deleting T-log file it is not good right
we will shrink the file only
Is it possible to delete T-log file what happed ?
AS per my knowledge t-log file are not deleted only truncated
i not correct plz correct me
Regards
kumar
Please read the article that Gail suggested you to read. Also, it is possible to delete a transaction log however that is never suggested.
If the log file is increasing, you need to investigate what is causing the log to grow so heavily?
Are you taking regular log backup?
Is there a bulk insert of data going on?
And yes, you can truncate the log file for once, if you know that it wont grow again to such a size.
August 25, 2009 at 6:39 am
kumar99ms (8/25/2009)
Is it possible to delete T-log file what happed ?
Sure it's possible, just not while the DB is in use. Doing so is asking for a damaged and possibly unusable database.
Go and read the article I refered you to. If you still have questions afterwards, please ask.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply