Post reply

Find out the Database downtime in last 30 days

  • May 5, 2011 at 12:08 am

    #148969

    Hi Fellas,

    I want to calculate the DB Uptime/Downtime for the last 30 days in Sql server 2005. Its quit possible there are multiple error logs created because of re-initialization of error logs. But is this possible to exactly calculate the downtime.

    Regs,

    SAM

  • May 5, 2011 at 4:51 am

    #1320298

    Anyway i there is something which can be used for getting the downtime, but not the duration of downtime. And that is "sp_readerrorlog". We can see the archived error log by putting sp_readerrorlog 1/2/3..

    But as i mentioned it wont be able to tell the duration of DB downtime. Any clue??

    Regards,

    SAM

Viewing 2 posts - 1 through 1 (of 1 total)

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