When was my Server restarted?

 

Temporary database tempdb is created whenever the Server is restarted. So you can know when Server was restarted by knowing the creation date of the tempdb

EXEC sp_helpdb tempdb

select crdate  from master..sysdatabases
where name='tempdb'

Published 09 June 2008 16:24 by Madhivanan
Filed under: ,

Comments

# re: When was my Server restarted?

08 June 2009 13:48 by vmvadivel

Though checking the creation date of TEMPDB will do the trick. Its not a guaranteed method.

Bcoz PSS when they do troubleshooting some tempdb issues could have used T3609 to recover tempdb instead of recreating it.

So the best method and the only method to trust 100% is to check the time in sysprocesses as I have shown in my blog post.

vadivel.blogspot.com/.../how-to-find-when-sql-server-was-last.html