January 9, 2012 at 1:12 pm
How do I delete the archived sql agent error logs on a development database? I have 9 months of archive errorlogs and I don't need more than the last months.
Thanks
January 10, 2012 at 11:30 am
xiaoxiaoli72 (1/10/2012)
Or call one of you: BI published on air max 90 Vancouver, STI, as well as B lackspot irreverant advertising and consumption of sneakers, you know a fair trading environment-friendly take on the logo free of charge through independent shoe retail sales is Credit card advertising free 70,000-circulation nike air max magazine, sparking talk of independence for Wall Street has Adbusters Nimes.
Spam. Nonsense. Reported.
January 10, 2012 at 11:49 am
This should prove useful.
http://technet.microsoft.com/en-us/library/ms178310.aspx
In short - Cycle the log.
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
January 10, 2012 at 11:56 am
jberg-604007 (1/9/2012)
How do I delete the archived sql agent error logs on a development database? I have 9 months of archive errorlogs and I don't need more than the last months.Thanks
http://www.mssqltips.com/sqlservertip/1916/best-practice-recycling-sql-server-agent-error-logs/
January 10, 2012 at 1:58 pm
Once the SQL Agent logs have scrolled off -- that is, been renamed as SQLAGENT.1, ~.2, etc., by SQL Server -- you can just go into Windows and delete them. SQL will only "protect" the current log file.
You can find the current path for SQL Agent files by right-clicking "SQL Server Agent" in SSMS and selecting "Properties", and looking at the "File Name".
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply