June 24, 2003 at 5:10 am
Greetings
I've got a 2000 server with SP 3 running on a cluster environment with about 30 small databases.
SQL Server logs were being filled OK, with general information about jobs killed and daily backup processes return status.
I'm looking at the logs right now and the last entry is dated 4 days ago. I've tried to refresh it, but it stays the same. I also tried to open a new EM window on the server itself, but the information is the same. 4 days ago information.
The information on the "physical" (disk) logfiles is the same.
Thanks to a critical application we used on that period (which had hourly TL backups) the logfile grew a lot more than the usual (630Kb vs the usual 10Kb), due to the additional backup logging. There were no other "strange" things happening around here... The last entry I've got is "Process ID 132 killed by hostname S302PC, host process ID 1744." after some backup information logging, which looks completely normal to me.
So my questions are: has anyone noticed this behaviour before? Is there any way to check if the server thread which does the logging is working and can it be reactivated?
Any hints on this?
June 24, 2003 at 9:02 am
Your question is so confusing.... If you want to see the server logging is working or not, change your server Audit level to All. You must re-start the server to take place this change
To change Audit level go to Enterprise manager-> Server properties -> Security -> Audit Level
Shas3
June 24, 2003 at 11:49 am
the server is not logging, altough it's working.
I just want to figure out any way to put it back as it was (logging) without having to restart the server.
June 24, 2003 at 3:53 pm
Maybe there's nothing to be logged. No jobs being killed, and possibly no backups happening because SQL Agent not started?
Could you have cycled SQL Server and forgot to restart SQL Agent?
From QA try:
RAISERROR ('Hello World', 0, 1) WITH LOG
Then:
exec sp_readerrorlog
You should see your "hello World" at the end of the results.
Cheers,
- Mark
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply