1

Topic: Date and time of the last reboot sql server

It is possible to learn somehow when the SQL Server last time rebooted?

2

Re: Date and time of the last reboot sql server

In a server broad gull is.

3

Re: Date and time of the last reboot sql server

Sandist;
The easy method is creation date temdb

4

Re: Date and time of the last reboot sql server

Gavrilenko Sergey Alekseevich;
SELECT crdate FROM master.dbo.sysdatabases
WHERE [name] =N'tempdb ';
So it is possible?

5

Re: Date and time of the last reboot sql server

Sandist wrote:

Gavrilenko Sergey Alekseevich;
SELECT crdate FROM master.dbo.sysdatabases
WHERE [name] =N'tempdb ';
So it is possible?

Date of start of the server in a broad gull more correct. And taking into account that if someone  interesting , type to eat away all accessible storage at server start also will decently differ.

6

Re: Date and time of the last reboot sql server

Gavrilenko Sergey Alekseevich;
At me the difference quitted in 35 seconds between log and creation date tempdb it is normal (not the big difference)?

7

Re: Date and time of the last reboot sql server

Sandist wrote:

Gavrilenko Sergey Alekseevich;
At me the difference quitted in 35 seconds between log and creation date tempdb it is normal (not the big difference)?

It to you to solve, whether such difference satisfies you.

8

Re: Date and time of the last reboot sql server

Sandist wrote:

Gavrilenko Sergey Alekseevich;
At me the difference quitted in 35 seconds between log and creation date tempdb it is normal (not the big difference)?

Looking as you will use it, if  position of the companion concerning coordinate that is the big difference

9

Re: Date and time of the last reboot sql server

Sandist;
select sqlserver_start_time from sys.dm_os_sys_info

10

Re: Date and time of the last reboot sql server

Shakill;
Thanks big.... This value coincides with broad gulls