Twitter

Follow SQLQuill on Twitter

Subscribe

MN Pass

How to: tell when a server is back up after a reboot

I learned this a long time ago.  It helps when building multiple servers, you’ve got a deadline and you need to reboot one or more.  Simply, fire up a command prompt and add the –t switch to the end of the ping command.

Ping ###.##.##.## –t

or

Ping <<ServerName>> –t

The –t will continually ping the server until you stop it (with Ctrl-C)….So after the server shuts down, you’ll get a Request Timed Out – every second until it’s back up.  Once you start seeing a response, it’s on the network – it may take another minute or two to be able to RPD to it.

How to: find the name of a server from an IP address

About 8 years ago I worked with a guy who taught me a lot of non SQL IT stuff.  He always explained things very well – if I asked.  He taught me how to find a server’s name by using the ping command and a switch.  I couldn’t remember how we did it and every time I’ve looked up how to do it, I couldn’t figure it out – until today.  Open a command prompt and:

Ping -a ###.##.##.##

Note the –a resolves addresses to hostnames.  Also, the –a needs to be in the front of the IP!  I think that’s the part I couldn’t get figured out.  I’ll now have it on my blog if I ever forget again.