Missing stored prcedures after a database restore using Red Gate software

On our Microsoft SQL 2005 server, we had a database corruption and during a restore process using Red Gate SQL Backup software, the stored procedures of the given database seem to be missing. Is this some funny little switch or something similar that is not restoring the procedures with the backup? If not, is there any way to get these back with the backups that we have. We've tried two separate backup files.
numb3rs1xAsked:
Who is Participating?
 
MohammedUConnect With a Mentor Commented:
It is not the switch. I believe it is either your backup file or restore process.

Have done the full restore? Yes then something wrong with your backup file or backup backup process.

If you are using object level recovery option in the restore process which is supported by some third party backup companies then you are not restored all the objects.

0
 
numb3rs1xAuthor Commented:
Slight correction. I guess all but 3 very important SPs were restored. A very strange problem indeed. Any suggestions would be appreciated.
0
 
Anthony PerkinsCommented:
The comment here http:http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_26879286.html?#a35108863 answered the question or at the very least led the author to the solution.
0
 
modus_operandiCommented:
Starting auto-close process to implement the recommendations of the participating Expert(s).
 
modus_operandi
EE Admin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.