You could restore it by right clicking on your device in iTunes and then Restore From Backup. You would have to go back to a backup that contained that sms though. Also if you did this you'd be losing messages and app data created after that backup date.