Post reply

Sql Server Logs

  • July 28, 2010 at 1:49 am

    #238139

    Hi,

    We have a sql server 2008 64-bit.

    Sometimes,sql server did not respond and we restarted the services.

    Now we fix a problem.

    But we want to know that when the problem was occuring.

    Unfortunately,We have no event log,it is deleted.

    Can we find restarting service log from SQL Server views?

    Best Regards,

  • July 28, 2010 at 4:52 am

    #1199156

    Check SQL Server Error log..If that wat u mentioning then check system logs..

  • July 28, 2010 at 5:05 am

    #1199159

    I checked but I have only 1 week Sql Server Error Logs .

    but I need 4 months logs:(

  • July 28, 2010 at 5:52 am

    #1199170

    You sure u cleaned the logs??

  • July 28, 2010 at 6:14 am

    #1199179

    Yes,I have only 1 week logs on sql server logs

  • July 28, 2010 at 6:38 am

    #1199188

    U checked the default folder??

    by the way y u need last 4 months info??

  • July 28, 2010 at 7:02 am

    #1199207

    Yes I need last 4 months info.I saw some error logs in the default folder.

    But they are not clear for me

  • July 28, 2010 at 5:25 pm

    #1199541

    I'm guessing I know the answer to this already, but here goes....

    Have you been backing up your binaries folder? If you have been then you could pull all your logs back from tape.

    Hope this helps,
    Rich

    [p]
    [/p]

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply