SQL Services recent restart datetime

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

SQL Services recent restart datetime

Author

Topic

learntsql

524 Posts

Posted - 2009-12-15 : 03:39:06

Hi..
How would i know when was my SQL Server services(database engine,SSRS,SSIS,SQL Agent etc...) are restarted.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-12-15 : 04:50:52

Look at the created date

EXEC sp_helpdb tempdb

Madhivanan

Failing to plan is Planning to fail

learntsql

524 Posts

Posted - 2009-12-15 : 05:11:48

Thanks madhivanan,
Will it create new tempdb even if i restart SQL Agent service(not database engine)

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2009-12-15 : 09:25:59

No it will not create new tempDB when you restart the SQL Agent Service.

But Yes it will create the Temp db every time the connection established to query the database.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources