Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

In managment studio there is a range of dates in Managment > SQL Server Logs that is missing. Where are these logs stored? Is there a way I can try to reload the missing logs if they are available somewhere?

share|improve this question
    
If the log files were deleted, their contents can be found in the Registry as well. –  user3914 Dec 9 '10 at 17:14
    
Where in the registry would I find them –  cpgascho Dec 9 '10 at 18:18

3 Answers 3

up vote 1 down vote accepted

Execute sp_readerrorlog in a new query window. This will read the latest SQL Server Error Log for you. In the first few lines you can get the location where the Error Logs are stored.

share|improve this answer
    
Thank you that did give me the location I was looking for. Just need to figure out a way to parse through these files and find out if the missing logs are here somewhere. Not sure what caused this to happen. –  cpgascho Dec 13 '10 at 15:18

Where are they stored? C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log

How do you have their management configured? In Mgt Studio, expand the Management folder, right click on SQL Server Logs, Configure. Default is six and then they roll off.

share|improve this answer
    
I do not have the box checked to limit the number of error logs before they are recycled. I am currently showing the current log plus 6 archive logs. In between the most recent archive log and the current log there is a 6 week gap of missing logs –  cpgascho Dec 9 '10 at 18:10
    
I don't have a folder called log in this location C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2008\MSSQL –  cpgascho Dec 9 '10 at 19:15
    
Should be under C:\Program Files\Microsoft SQL Server unless moved. –  jl. Dec 9 '10 at 20:26
    
Would this be it? C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100727_173104 –  cpgascho Dec 9 '10 at 20:35

Dont you have a backup. Restore it somewhere and get the logs backed up in a diffrent location and try to take them to your default location

share|improve this answer
    
We just set this server up a month ago and a backup is on the to-do list but it hasn't been done yet (Bad i know) –  cpgascho Dec 13 '10 at 14:11
    
thats a terrible problem. Sorry I have no solution from my side –  Andrew Collins Dec 14 '10 at 15:17

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.