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

• LutzM

  SSC Guru

  Points: 107049

  More actions

  January 10, 2012 at 11:30 am

  #1431327

  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: 281344

  More actions

  January 10, 2012 at 11:49 am

  #1431341

  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

  January 10, 2012 at 11:56 am

  #1431343

  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: 101192

  More actions

  January 10, 2012 at 1:58 pm

  #1431401

  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".