Clarity

I wanted to know whether my DB is UP or Down for the past one day. Can we achieve this by writing any query? If yes please let me know.

Thanks in Advance. 

Ummmm if your DB is down, not sure any query is going to help you!

Google suggests things like ; Find out how long the sql server service has been running, from t-sql - Stack Overflow 

The application log files will report errors what the application can not connect to the database though - you could look in there?

Hi Dave,

Greetings!!

I wanted to know the next day whether there is any Database Down or anything I want to put them in a process thus I cant use Logs for that. Also, can I know the same for Dataware house Status as well? 

Thanks,

Vamshi

Have you even looked at the link I gave you?

Yes, I did. In that link, We have db created date info.

No, you have the created date of the tempdb, which apparently tells you when the database was last started.

I would check the event application logs for events which have a source of MSSQLSERVER.

If you know what you are looking for in these events,  you could write a small powershell script to query for specific types of events.

$Date = (Get-Date).AddDays(-1)
Get-WinEvent @{logname='application';id=17137; StartTime = $Date } | select logname, timecreated, id, message

V/r,

Gene