Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Help required to Fetch the availability report

Author  Topic 

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2012-01-12 : 02:11:29
Hi All,

I need to generate the availability report i.e how much time the Sql server was available/ not available (down) between the date Range.


I know sp_readerrorlog will help me, but i expect some other efficient way..

Can any one help me on this?

Senthil Kumar C
------------------------------------------------------
MCITP - Database Administration SQL SERVER 2008
MCTS - Database Development SQL SERVER 2008

biswajitdas
Starting Member

44 Posts

Posted - 2012-01-12 : 13:13:23
might be the below thread discussion will help you

http://social.technet.microsoft.com/Forums/en/operationsmanagerauthoring/thread/7b9bf4ab-565c-4a7c-8f00-13444e85aa08


Sr Sql server DBA/Artitech
Go to Top of Page
   

- Advertisement -