I have a sql db for my website www.weeweeslap.com the datebase (mdf) file is closing in on 800 MB where the logfile (ldf) is closing on on 10 gigs. Is there a way to make it more convenient size wise? Make it smaller? Not that size is a problem on my computer but it takes an hour to rar them two files if I want to rar them. I do use the auto backs ups and that too turns out to 756+ mb. Well, any help on reducing the size of these files will be appreciated. Thanks.
a 10Gig log file means your db is setup wrong, in the properties for the db you should set the recovery level to simple. then do a backup and perform a shrink operation on the logfile.
Right on. Thanks Huwr! I did what you said and logfile went down to just 500 kb and the database went down to a little over 700 MB. uch better than the grand total of 11 gigs that it was before Thanks Huwr!
Topic Locked
Posted - 18 December 2007 : 23:42:51
