A few weeks ago I saw a brilliant performance from Prince on TV (MTV unplugged?)
he played acoustic guitar for a live audience, played some cover-intro's
and some of his own songs....I wonder if I can but a DVD from this show?

That was the MTV special Prince did to launch/promote the Musicology album. It is not officially available on dvd but there are unofficial bootleg dvds knocking about.