Abu Dawud Book 2, Hadith Number 1170.
Narated By Anas ibn Malik : The people of Medina had a drought during the time of the Prophet (PBUH).
While he was preaching on a Friday, a man stood up and said: Apostle of Allah, the horses have perished, the goats have perished, pray to Allah to give us water. He spread his hands and prayed.
Anas said: The sky was like a mirror (there was no cloud). Then the wind rose; a cloud appeared (in the sky) and it spread : the sky poured down the water. We came out (from the mosque after the prayer) passing through the water till we reached our homes. The rain continued till the following Friday. The same or some other person stood up and said: Apostle of Allah, the houses have been demolished, pray to Allah to stop it.
The Apostle of Allah (PBUH) smiled and said: (O Allah), the rain may fall around us but not upon us. Then I looked at the cloud which dispersed around Medina just like a crown.