August 31, 2005 at 11:26 am
I had a huge sql errr log created this morning and log is configured to keep only 6 file.s unfortuantely the servergto rebooted a few times because fo which this huge file got deleted . Is there any way it can be retrieved from MSSQ? does it store that file anyplace other than e:\msssql\log? ANy help on this will be greatly apprecaited as i need to look into that file and see where the problem started. TIA
August 31, 2005 at 2:13 pm
I think you are out of luck, the file is gone.
September 1, 2005 at 4:17 pm
You canot retrieve the file but you can cover yourself in the future by configuring the SQL Server to keep more log files. I personally recommend 20 since it will help you out in clsutering and service pack applications, etc.
In EM go to Management | SQL Error Logs | Right clish | select configure
You can also use an xp_regwrite command in a script to automate things but the registry key is different from a default instance and a named instance.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply