1. First Option is to check when the tempdb database is created. This is the exact time at which the services were restarted.
SELECT crdate AS 'SQL Server service started Time'
FROM master.dbo.sysdatabases
WHERE name = 'tempdb'
2. Second Option is the information about the database startup will be available while executing the command,
exec xp_readerrorlog
SELECT crdate AS 'SQL Server service started Time'
FROM master.dbo.sysdatabases
WHERE name = 'tempdb'
2. Second Option is the information about the database startup will be available while executing the command,
exec xp_readerrorlog
No comments:
Post a Comment