how to delete the sql agent error logs on a development database

Question

how to delete the sql agent error logs on a development database

maroon-78

Ten Centuries

Points: 1014
More actions
January 9, 2012 at 1:12 pm

#391264

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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

LutzM SSC Guru Points: 107049 More actions · Answer 1

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.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

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

padhis SSCommitted Points: 1762 More actions · Answer 3

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

more on this..

http://www.mssqltips.com/sqlservertip/1916/best-practice-recycling-sql-server-agent-error-logs/

ScottPletcher SSC Guru Points: 101097 More actions · Answer 4

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) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".