Shrink/reduce Transaction Log files

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..?
knobbylowboyAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
matrix_aashConnect With a Mentor Commented:
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.



0
 
Aneesh RetnakaranDatabase AdministratorCommented:
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
0
All Courses

From novice to tech pro — start learning today.