Post reply

How to find when my SSRS service was last restarted ?

  • June 20, 2013 at 1:38 am

    #294887

    Expertrs,

    How to find when my SSRS service was last restarted ? Not the DB Engine.. Only Reporting services..

    Thanks in advance..

    Smith.

  • June 20, 2013 at 2:19 am

    #1625746

    Hi,

    You need to look at the log files in the following directory:

    C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles

    (Assuming you're running 2008R2) Your directory may differ slightly. When the service starts or restarts a new logfile is created.

    Thanks,

    Simon


    MCSE: Data Platform
    MCSE: Business Intelligence
    Follow me on Twitter: @WazzTheBadger
    LinkedIn Profile: Simon Osborne

  • June 24, 2013 at 1:16 am

    #1626669

    s_osborne2 (6/20/2013)

    Hi,

    You need to look at the log files in the following directory:

    C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles

    (Assuming you're running 2008R2) Your directory may differ slightly. When the service starts or restarts a new logfile is created.

    Thanks,

    Simon

    Thank you so much. So I need to see the log file creation date or there will be an entry in the log file for the time it started ?

  • June 24, 2013 at 4:21 am

    #1626713

    Hi,

    The creation date/time will give a good indication but i'd say it was worth having a read of the log to see if there is anything in there that may give you more information. I'm not sure of the actual content of the file because I've only ever checked it when my service had problems starting.

    Thanks,

    Simon


    MCSE: Data Platform
    MCSE: Business Intelligence
    Follow me on Twitter: @WazzTheBadger
    LinkedIn Profile: Simon Osborne

Viewing 4 posts - 1 through 3 (of 3 total)

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