• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 246
  • Last Modified:

Fault finidng in MS SQL Server 2008

I have an application that is running on SQL Server 2008.  It has been runing without problem for a number of years now.

However now it has started having a few problems.  It often reports key violations on one of the tables.  As i know the user is not entering invalid data i must assume that somewhere in my application, or in the database, there are problems.

I was wondering if there are any error logs that might help?  EIther ones produced by SQL Server, or by the OS.  I suspect problems with indexes, or space, log sizes etc...

0
soozh
Asked:
soozh
  • 2
  • 2
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
if you get "key violations", this is usually a logical error in some UPDATE, DELETE or INSERT code of your application.
like it tries to insert a row with a key that already exists.

there will be no other "error log" than the reported error that can help.
get the application code, compare with data, test on test/copy db etc ...
0
 
soozhAuthor Commented:
i understand why and how key violation is caused.  What i am looking for is if there are some logs that SQL Server keeps.

I remember a problem like this last year that was caused by the lack of space or something like that.  So i want to be able to examine the health of the database...
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>What i am looking for is if there are some logs that SQL Server keeps.
none about those errors as such.

> So i want to be able to examine the health of the database...
check out the ERRORLOG file of sql server ...
0
 
soozhAuthor Commented:
where can i find that?
0
 
Anthony PerkinsCommented:
Under Management | SQL Server Logs in SSMS.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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