Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 815
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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