You can restore it from a database backup even without restoring the backup. You need a tool for comparing and synchronizing object schemas (such as SQL Diff). Set the database backup as a source, the live database as a destination, filter only the stored procedure you want to restore