purge a log file

Hello,

I would like to use the built in logging feature to log to a text file.

Is there a way to purge the log peridically (only keep enties for the last 30 days, etc).

Thanks,

Michael

There's no built in feature for doing this. You would have to build something yourself.

If you require this as a feature then request it at Microsoft Connect.

-Jamie

Public Chat: SQL Server 2005 Beta 2, What's New

Join members of the Microsoft development team as they chat about what's new
in SQL Server 2005 Beta 2. One major new feature that's been announced in
Beta 2 is data encryption. Come chat about other new features and changes
that exist in this highly anticipated beta of the next version of SQL
Server.
July 28, 2004
10:00 - 11:00 A.M. Pacific time
1:00 - 2:00 P.M. Eastern time
17:00 - 18:00 GMT
See the announcement at
http://www.microsoft.com/technet/com.../default.mspx.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Don't forget tomorrow's chat!
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:O9KEh9EcEHA.2940@.TK2MSFTNGP10.phx.gbl...
> Join members of the Microsoft development team as they chat about what's
> new
> in SQL Server 2005 Beta 2. One major new feature that's been announced in
> Beta 2 is data encryption. Come chat about other new features and changes
> that exist in this highly anticipated beta of the next version of SQL
> Server.
> July 28, 2004
> 10:00 - 11:00 A.M. Pacific time
> 1:00 - 2:00 P.M. Eastern time
> 17:00 - 18:00 GMT
> See the announcement at
> http://www.microsoft.com/technet/com.../default.mspx.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
> rights.

Public Chat: SQL Server 2005 Beta 2, What's New

Join members of the Microsoft development team as they chat about what's new
in SQL Server 2005 Beta 2. One major new feature that's been announced in
Beta 2 is data encryption. Come chat about other new features and changes
that exist in this highly anticipated beta of the next version of SQL
Server.
July 28, 2004
10:00 - 11:00 A.M. Pacific time
1:00 - 2:00 P.M. Eastern time
17:00 - 18:00 GMT
See the announcement at
http://www.microsoft.com/technet/com.../default.mspx.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Don't forget tomorrow's chat!
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:e5BFp2EcEHA.2408@.tk2msftngp13.phx.gbl...
> Join members of the Microsoft development team as they chat about what's
> new
> in SQL Server 2005 Beta 2. One major new feature that's been announced in
> Beta 2 is data encryption. Come chat about other new features and changes
> that exist in this highly anticipated beta of the next version of SQL
> Server.
> July 28, 2004
> 10:00 - 11:00 A.M. Pacific time
> 1:00 - 2:00 P.M. Eastern time
> 17:00 - 18:00 GMT
> See the announcement at
> http://www.microsoft.com/technet/com.../default.mspx.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
> rights.

Public Chat: SQL Server 2005 Beta 2, What's New

Join members of the Microsoft development team as they chat about what's new
in SQL Server 2005 Beta 2. One major new feature that's been announced in
Beta 2 is data encryption. Come chat about other new features and changes
that exist in this highly anticipated beta of the next version of SQL
Server.
July 28, 2004
10:00 - 11:00 A.M. Pacific time
1:00 - 2:00 P.M. Eastern time
17:00 - 18:00 GMT
See the announcement at
http://www.microsoft.com/technet/com.../default.mspx.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Don't forget tomorrow's chat!
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:O9KEh9EcEHA.2940@.TK2MSFTNGP10.phx.gbl...
> Join members of the Microsoft development team as they chat about what's
> new
> in SQL Server 2005 Beta 2. One major new feature that's been announced in
> Beta 2 is data encryption. Come chat about other new features and changes
> that exist in this highly anticipated beta of the next version of SQL
> Server.
> July 28, 2004
> 10:00 - 11:00 A.M. Pacific time
> 1:00 - 2:00 P.M. Eastern time
> 17:00 - 18:00 GMT
> See the announcement at
> http://www.microsoft.com/technet/com.../default.mspx.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
> rights.

Public Chat: SQL Server 2005 Beta 2, What's New

Join members of the Microsoft development team as they chat about what's new
in SQL Server 2005 Beta 2. One major new feature that's been announced in
Beta 2 is data encryption. Come chat about other new features and changes
that exist in this highly anticipated beta of the next version of SQL
Server.
July 28, 2004
10:00 - 11:00 A.M. Pacific time
1:00 - 2:00 P.M. Eastern time
17:00 - 18:00 GMT
See the announcement at
http://www.microsoft.com/technet/com.../default.mspx.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Don't forget tomorrow's chat!
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:e5BFp2EcEHA.2408@.tk2msftngp13.phx.gbl...
> Join members of the Microsoft development team as they chat about what's
> new
> in SQL Server 2005 Beta 2. One major new feature that's been announced in
> Beta 2 is data encryption. Come chat about other new features and changes
> that exist in this highly anticipated beta of the next version of SQL
> Server.
> July 28, 2004
> 10:00 - 11:00 A.M. Pacific time
> 1:00 - 2:00 P.M. Eastern time
> 17:00 - 18:00 GMT
> See the announcement at
> http://www.microsoft.com/technet/com.../default.mspx.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
> rights.

Public Chat: SQL Server 2005 Beta 2, What's New

Join members of the Microsoft development team as they chat about what's new
in SQL Server 2005 Beta 2. One major new feature that's been announced in
Beta 2 is data encryption. Come chat about other new features and changes
that exist in this highly anticipated beta of the next version of SQL
Server.
July 28, 2004
10:00 - 11:00 A.M. Pacific time
1:00 - 2:00 P.M. Eastern time
17:00 - 18:00 GMT
See the announcement at
http://www.microsoft.com/technet/co...s/default.mspx.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.Don't forget tomorrow's chat!
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:e5BFp2EcEHA.2408@.tk2msftngp13.phx.gbl...
> Join members of the Microsoft development team as they chat about what's
> new
> in SQL Server 2005 Beta 2. One major new feature that's been announced in
> Beta 2 is data encryption. Come chat about other new features and changes
> that exist in this highly anticipated beta of the next version of SQL
> Server.
> July 28, 2004
> 10:00 - 11:00 A.M. Pacific time
> 1:00 - 2:00 P.M. Eastern time
> 17:00 - 18:00 GMT
> See the announcement at
> http://www.microsoft.com/technet/co...s/default.mspx.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
> rights.

Public Chat: SQL Server 2005 Beta 2, What's New

Join members of the Microsoft development team as they chat about what's new
in SQL Server 2005 Beta 2. One major new feature that's been announced in
Beta 2 is data encryption. Come chat about other new features and changes
that exist in this highly anticipated beta of the next version of SQL
Server.
July 28, 2004
10:00 - 11:00 A.M. Pacific time
1:00 - 2:00 P.M. Eastern time
17:00 - 18:00 GMT
See the announcement at
http://www.microsoft.com/technet/community/chats/default.mspx.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.Don't forget tomorrow's chat!
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:e5BFp2EcEHA.2408@.tk2msftngp13.phx.gbl...
> Join members of the Microsoft development team as they chat about what's
> new
> in SQL Server 2005 Beta 2. One major new feature that's been announced in
> Beta 2 is data encryption. Come chat about other new features and changes
> that exist in this highly anticipated beta of the next version of SQL
> Server.
> July 28, 2004
> 10:00 - 11:00 A.M. Pacific time
> 1:00 - 2:00 P.M. Eastern time
> 17:00 - 18:00 GMT
> See the announcement at
> http://www.microsoft.com/technet/community/chats/default.mspx.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
> rights.

Public Chat: SQL Server 2005 Beta 2, What's New

Join members of the Microsoft development team as they chat about what's new
in SQL Server 2005 Beta 2. One major new feature that's been announced in
Beta 2 is data encryption. Come chat about other new features and changes
that exist in this highly anticipated beta of the next version of SQL
Server.
July 28, 2004
10:00 - 11:00 A.M. Pacific time
1:00 - 2:00 P.M. Eastern time
17:00 - 18:00 GMT
See the announcement at
http://www.microsoft.com/technet/community/chats/default.mspx.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.Don't forget tomorrow's chat!
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:e5BFp2EcEHA.2408@.tk2msftngp13.phx.gbl...
> Join members of the Microsoft development team as they chat about what's
> new
> in SQL Server 2005 Beta 2. One major new feature that's been announced in
> Beta 2 is data encryption. Come chat about other new features and changes
> that exist in this highly anticipated beta of the next version of SQL
> Server.
> July 28, 2004
> 10:00 - 11:00 A.M. Pacific time
> 1:00 - 2:00 P.M. Eastern time
> 17:00 - 18:00 GMT
> See the announcement at
> http://www.microsoft.com/technet/community/chats/default.mspx.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
> rights.