Transaction Log getting increased

Transaction Log in SQL Server is growing tremendously. Pls suggest can we delete the transaction log or is there any way to control.
tsravankAsked:
Who is Participating?
 
Jokra_the_BarbarianConnect With a Mentor Commented:
You will want to create some type of maintenance plan to do a combination of full daily backup and hourly backups of the log file. When you do the backups, you will want to truncate and shrink the log. This will keep the log from becomming bloated.
0
 
arbertConnect With a Mentor Commented:
Agree, put a backup plan in place and shrink the log.

In the mean time, you can run this in query analyzer and probably get some of your space back.

backup log yourdbnamehere with truncate_only
go
dbcc shrinkfile(2,0)
go


Brett
0
 
Jokra_the_BarbarianCommented:
Both arbert and myself provides viable solutions to the problem. I'd be cool with point split.
0
 
arbertCommented:
Agree...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.