SQL Server

Question

Post reply

SQL Server

subbarayudu.net 37258

Mr or Mrs. 500

Points: 540
More actions
February 13, 2010 at 8:44 am

#220567

How to know when the sql server is started ?
Yester day midnight server is restarted. so now how to know when server is started ?
How to know logfile size only.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135376 More actions · Answer 1

Do you mean SQLserver startup time or actual hardware startup time ?

SQLServer uptime: http://www.sqlservercentral.com/scripts/Administration/63771/

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

Or do you mean:

How to get alerted when SQL Server is restarted?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

krayknot SSCertifiable Points: 7998 More actions · Answer 3

create a job in that sql server and set its schedule type to "Start automatically when SQL server agent starts" and set the notification to Email / Page or net send.

kshitij kumar
kshitij@krayknot.com
www.krayknot.com

subbarayudu.net 37258 Mr or Mrs. 500 Points: 540 More actions · Answer 4

Hi,

I explained the scenario...

Last one month back i restart the server because of application enhancement implement into the production...

now how to know a new person when its restarted or started the server.

GTR SSCrazy Eights Points: 8007 More actions · Answer 5

You can see all the details like when SQL Server\Agent started and stopped in SQL Server Error logs. You should be able to see this information in windows event logs also.

EnjoY!

EnjoY!

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

Three options were presented for that.

You can check the create date of Tempdb as suggested in the script from Alz

You can check sql error logs

or

You can check Windows Event Log. You would find it in the application event log.