We have SOX Audits going on and i was asked to show errologs,
there is option in sql server which says limit the number of errorlogs 6 to 99 i have unchecked this option long back but today when i went to see 6 month old log it doesnt have records for that date,Our sql server is restarting everynight
in off business hours ( i am mentioning this becoz this does same job as sp_cycle_errorlog)
i have log records from last year but entries for this year are missing, i dont know much about "sp_cycle_errorlog" , so what settings should i do to make my production server show Archive#1 ............ Archive#N as Logs separated by individual days without any break in sequence or missing days pls Help
An errorlog is created when the service starts, or when you issue sp_cycle_errorlog. Any reboot of the server, or any restart of the service will cause a new errorlog to be generated. It is not uncommon for service pack installs to generate 3 or 4 errorlogs.
A more interesting question may be why is the SQL Server restarting every night?
I am surprised i have all the logs from Sept2010 to Dec 2010, then i see Log Records For Month OF August 2011...In between everything is missing?? y is that???........
, our server dont have much memory and our database size is big, sql server on 64 bit takes all the memory, though we have option to limit its memory, but there are 3-4 other applications installed on this server, ( before i had alloted 12GB of Memory to SQL Server out OF 16GB )
Our Index Rebuilding JOB took all the memory and left our database in Inconsistent mode
Last edited by amitwadhawan123; 08-12-11 at 12:39.
The top of the errorlog will tell you if the new errorlog was created by a restart of the service, or an execution of sp_cycle_errorlog. If you see messages about starting up databases, and listening on IP addresses, the service was restarted.
If you see a message near the top of the errorlog that says :
The error log has been reinitialized. See the previous log for older entries.
then someone ran sp_cycle_errorlog. Remember, this can be done by a windows scheduler task, or even a SQL Agent job.