troubleshooting Question

managing sql log files - recommendations please

Avatar of websss
websssFlag for Kenya asked on
Microsoft SQL ServerMicrosoft SQL Server 2008
9 Comments2 Solutions48 ViewsLast Modified:
Hi

I have a asset tracking app which tracker people and cars, we use sql server 2014 enterprise
Currently the MDF is at 3gb and the LDF is at 33GB

the recovery model is set to full, and i've just left it that way, but now the log file is becoming too big, I need to manage that properly

One suggestion from the team was to set the log file to 10GB, and have a sliding thing so it only keeps the latest data (we only really care about the last 1 month/ 1 week but it we keep up to 1 year)

Does this sliding thing actually exist?

based on the brief above, how would you manage this large log file?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros