troubleshooting Question

Single Stored Procedure to Remove Log Files

Avatar of cnxmax
cnxmax asked on
Microsoft SQL ServerEmail ProtocolsMicrosoft SQL Server 2005
6 Comments4 Solutions353 ViewsLast Modified:
I have a database that gets a lot of activity, but it's not really data that is critical for long-term archiving. I need to know if I can create a stored procedure that I can run a few times a day to basically delete all of the log files.

From what I understand, log files need to be backed-up before they are removed. I need some kind of procedure to do the backup then remove the log files (or shrink them). If it's possible to delete the logs without backup I would prefer that.

Is something like this possible?
ASKER CERTIFIED SOLUTION
ola

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 4 Answers and 6 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 4 Answers and 6 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