Large log file on SharePoint DB which I'm hoping to reduce,

I'm trying reduce  the logfile on a SharePoint Database that I think it unnecessarily large.
It's the sp_WebAnalyticsStaging DB, I'm not sure what this does even.

The DB size is 129MB and the logfile is 16GB!
It's the initial size of the logfile that looks odd, it' set to 15898 MB, not sure why.

Can I just reduce the initial size of this logfile?

It's SP 2010,
ICT EngineerHead of ICTAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David Johnson, CD, MVPRetiredCommented:
you need to do a sql aware backup then the log files should be automatically truncated
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> Can I just reduce the initial size of this logfile?

No, you can't reduce it if there are any active transactions in the log file..

If you want to reduce the log file size, then Take a Log backup of your database and then you should be able to Shrink the log file to 1 GB. Also you can set the Initial size to 1 GB now..
Hope this helps..

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
austin minorCommented:
Are you doing regular log backups?

If it has grown out of control, then you can run a shrink on it to shrink the actual datafile size.

Sharepoint log files growing out of control: https://blogs.msdn.microsoft.com/bharry/2009/10/30/sharepoint-log-files-growing-out-of-control/
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.