I have a simple question (but not a simple answer) here.
Is there a way to restore, with selected DB, its procedures?
Whenever I restore a SQL DB it doesn't bring along its procedures.
Stored Procedures are backed up and restored with databases. You shouldn't need to do anything special for this.
Is this a special "view" or replication information that is missing after the restore?
Also, what version of BE and SQL are you running?