knobbylowboy
asked on
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..?
How can I reduce the size of these transaction logs to something more reasonable..?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://sqlserver2000.databases.aspfaq.com/how-do-i-reclaim-space-in-sql-server.html