| Author |
Topic |
|
tomislavg
Yak Posting Veteran
51 Posts |
 Posted - 2011-01-24 : 08:11:30
|
| Hi All,I have SQL 2005 and I noticed some missing dates from my SQL server log file. Example I am missing dates from 13-21 Jan 2011? Where is it.... and I have all the dates before and after.I check the Win event file - Security and see that there was activity on 19 Jan and I know that they were connecting to SQL but SQL log didn't record it. Any help....Thanks a lot, |
|
|
tomislavg
Yak Posting Veteran
51 Posts |
Posted - 2011-01-28 : 13:10:26
|
| NOBODY, it happened again, I am missing now from 22 - 28 Jan log.Why I can not even find any solution? Could it be that nobody had any issues like this with SQL system log? |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2011-01-28 : 13:56:40
|
| Do you know what a SQL server log file is?It sounds like you are talking about something completely different.CODO ERGO SUM |
|
|
|
tomislavg
Yak Posting Veteran
51 Posts |
Posted - 2011-01-28 : 14:23:05
|
It is system SQL log, where you can see and trace events like login, failed login etc..., not the DB log file.quote:
Originally posted by Michael Valentine Jones
Do you know what a SQL server log file is?It sounds like you are talking about something completely different.CODO ERGO SUM
|
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2011-01-28 : 14:41:08
|
quote:
Originally posted by tomislavg
It is system SQL log, where you can see and trace events like login, failed login etc..., not the DB log file.quote:
Originally posted by Michael Valentine Jones
Do you know what a SQL server log file is?It sounds like you are talking about something completely different.CODO ERGO SUM
Are you talking about the SQL Server Error log files?What tool (application) do you use to look at the "system SQL log"?CODO ERGO SUM |
|
|
|
tomislavg
Yak Posting Veteran
51 Posts |
Posted - 2011-01-29 : 02:40:16
|
Yes it is, SQL Server Error log files. Sorry I didn't mention this from the beggining, it would make it much easier....quote:
Originally posted by Michael Valentine Jones
quote:
Originally posted by tomislavg
It is system SQL log, where you can see and trace events like login, failed login etc..., not the DB log file.quote:
Originally posted by Michael Valentine Jones
Do you know what a SQL server log file is?It sounds like you are talking about something completely different.CODO ERGO SUM
Are you talking about the SQL Server Error log files?What tool (application) do you use to look at the "system SQL log"?CODO ERGO SUM
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tomislavg
Yak Posting Veteran
51 Posts |
Posted - 2011-01-30 : 04:13:30
|
| It is:Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86) May 26 2009 14:24:20 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tomislavg
Yak Posting Veteran
51 Posts |
Posted - 2011-01-30 : 15:36:25
|
They are inside the individual files.... not like the whole set is missing... only thing is that I noticed is one message before the missing log..The SQL Netweork Interface library could not deregister the SPN for the SQL server......thanks Tara for your help...quote:
Originally posted by tkizer
Are they missing inside the individual files, or are you expecting new files for each day?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
![]() ![]() ![]() ![]() ![]() |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tomislavg
Yak Posting Veteran
51 Posts |
Posted - 2011-01-30 : 16:31:59
|
| I will try to sort it out, at least I know where to go from here....Thanks |
|
|
|
|
SQL server log mistery