I have database for a project i'm working on. yesterday i restored it from an old backup and the schema changed back to a earlier state.
but now all the sstored procedures , views etc are missing and the project system can't use it and work.
so is there any way to restore or rollback to the state of the database to yesterdays state?
ASAP!! since the submission date is on 15th or earlier