The video features a guy playing guitar, his dog is about to get sent into space in a rocket, he says goodbye to his dog and the dog gets sent into space, it´s a pretty sad song and video!
It´s from the late 90s.

The Motorhomes - Into The Night
I was looking for it for quite some time :)