How to get last system shutdown time in Sql server when
restarted system?
Answer Posted / gaurav.verma4210
SELECT * from
sys.databases
is used for find the id of database.
SELECT create_date
FROM sys.databases
WHERE database_id = 2
Tempdb db is recreated each time SQL Server is restarted so
the created date time of TEMPDB will also give you the date
and time of the last restart of the instance.
Is This Answer Correct ? | 8 Yes | 6 No |
Post New Answer View All Answers
What is 2nf normalization?
What is the purpose of optimization?
What is the difference between sdf and mdf?
What options are available to audit login activity? : sql server security
What are different types of schemas?
What are diverse clauses that form a part of sql?
Define right outer join?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
How to resolve the orphan use problem? : sql server security
What are the differences between substr and charindex in sql server.
What is co-related sub query?
what is a join? : Sql server database administration
Who is the owner of a schema in ms sql server?
Difference between aggregate functions of sql?
What is bulkcopy in sql?