How do I increase the number or error logs that SQL Server keeps?
Oct 12, 2009 at 01:03 PM
Steve Jones - Editor ♦♦
Oct 15, 2009 at 05:42 AM
Ben Adderson ♦♦
There is a registry edit you can make, see this support article for 2000 and 2005.
Also in 2005 and 2008, there is an option in SSMS, when you right click 'SQL Server Logs' and choose Configure
Edit: links for SSMS : SQL2005, SQL2008
Oct 12, 2009 at 01:28 PM
Kev Riley ♦♦
Oct 13, 2009 at 05:39 AM
This link as the answer for 2005/08 - its basically a pictorial version of whats presented above http://www.mssqltips.com/tip.asp?tip=1835
Oct 13, 2009 at 09:32 PM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Oct 12, 2009 at 01:03 PM
Seen: 1996 times
Last Updated: Oct 15, 2009 at 05:42 AM
Checking when the SQL Instance started
Compatibility Level Change
Good book on dynamic SQL
What are the uses of DBCC commands?
Execute a Query against multiple servers
Can I detach a filegroup?
Can I tell when a stored procedure was last executed or who executed it?
Adding space to a database
Unable to connect to sql server 2008
Robocopy very slow in sql