[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 818
  • Last Modified:

How Do I configure error log settings?

I would like to turn off error logging, or instruct SQL to overwrite log files.  Do you know how I can do this using SQL 2005 express and Management Studio Express?
0
alanrogerson2
Asked:
alanrogerson2
  • 2
  • 2
  • 2
  • +1
1 Solution
 
PaultheBrokerCommented:
Are talking about error logging or  transaction logging?  To my knowledge, errors are typically returned to the application for the application to write in an error log file...so that would be handled in your application.

Transaction log files on the other hand are part of the backup/restore strategy of the database.  To turn them off,
ALTER DATATBASE myDatabase
SET RECOVERY SIMPLE
0
 
alanrogerson2Author Commented:
Every few seconds an entry is being made in both the event viewer application log and the sql log file in program files/SQL Server

I would like to turn this off.
0
 
Anthony PerkinsCommented:
Can you tell us what is that entry in "the event viewer application log and the sql log file"?
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Anthony PerkinsCommented:
Also, when you get a chance the following questions appear to have fallen through the cracks and are now considered abandoned:

1 08/28/2007 500 Delphi and Web Application ... Open Delphi Programmi...
2 08/02/2007 500 Display Rows as columns usi... Open SQL Server 2005
0
 
alanrogerson2Author Commented:
it is a failed logon attempt.  I am using a hosted server on a standard SQL server port so many ip addresses are trying to get into the server but are failing.  I would like to stop logging failures.  

Thanks for the reminder about the open questions.
0
 
PaultheBrokerCommented:
So these are hacking attempts that are failing?   Actually this happens to me to (I will never implement a hosted server on the default ports again !!!! :)  ).   I look forward to hearing if anyone has a solution....
0
 
Cedric_DCommented:
In SQL Server Configuration Manager, dbl-click on "SQL Server" service, go to Advanced tab, and add three symbols ";-n" to Startup Parameters, then restart service.

But this will eliminate only Windows Event Logging.
As I know, you cannot prevent SQL Server to create ERRORLOG files.
But you can "wipe out" any information from them by calling
DBCC ERRORLOG    seven times :)

0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now