I have a fairly simple DB, One Log file, one data file, its got half a dozen tables in it that are used for a web based app that allows users to look each other up (think online telephone directory with a few extra bits and you are there), there's a data feed that adds new lines each day as users data changes or new people get added. But this is a couple of hundred or so lines a day, the tables hold about 40,000 data lines as we never delete data just retire it.
The problem is the main data file is about 200Mb, the Log file however is 3.8Gb. Now we did import and re-import various bits initially and clear down tables and such. But I don't understand why i can't shrink the log file. I've tried everything I can think of. I've even detached and re-attached the DB. Still no joy.
The file size/usage is
data file 200Mb size in use 117Mb
log file 3749.99Mb size in use 3719.89Mb
Anyone have any suggestions for things to look at?
many thanks
Steve
Hi,look here:
http://www.aspfaq.com/show.asp?id=2471
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment