We help IT Professionals succeed at work.

Shrink/reduce Transaction Log files

knobbylowboy
knobbylowboy asked
on
Hi, I have an SQLServer 2000 DB with a 400MB data file and a 23GB (!) log file.  The logfiles are not part of the backup plan.  

How can I reduce the size of these transaction logs to something more reasonable..?
Comment
Watch Question

AneeshDatabase Consultant
BRONZE EXPERT
Top Expert 2009

Commented:
You need to take regular backups of your log file, better schedule for backuping up at least once in an hr

http://sqlserver2000.databases.aspfaq.com/how-do-i-reclaim-space-in-sql-server.html
DBCC SHRINKFILE(log filename, 1000)
BACKUP log databasename WITH TRUNCATE_ONLY
DBCC SHRINKFILE(log filename, 1000)

This shrink the transaction log file to 1000 mb., you can mention the size whatever you want to shrink it to

Hope this helps

Thanks,

Aash.



Explore More ContentExplore courses, solutions, and other research materials related to this topic.