April 20, 2015 at 10:09 am
I needed help with the log file rotation and cleanup script and how to remove the log file older then x days.
April 20, 2015 at 10:12 am
Just so we are clear, about which log file are you speaking?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 20, 2015 at 10:19 am
Activity logs
April 20, 2015 at 3:48 pm
Do you mean transaction logs or error logs?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 21, 2015 at 2:19 am
Error logs have their own built-in retention, transaction logs you don't delete at all. Specifically what logs are you talking about?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply