0

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

Edited by sandeepani: stored procedures

3
Contributors
3
Replies
4
Views
7 Years
Discussion Span
Last Post by gbraden
0

I'm afraid there isn't a way. I've seen this question asked time after time in various forums and blogs and the answer is no. SQL Server completely wipes your data and replaces it with the recovered backup file. Cannot be recovered via transaction logs either.

On Windows, do you have automatic recovery turned on? Maybe you can recover the last mdf/ldf's and then attach those files. If it's hosted elsewhere, perhaps they have a backup.

Good luck!

0

I'm afraid there isn't a way. I've seen this question asked time after time in various forums and blogs and the answer is no. SQL Server completely wipes your data and replaces it with the recovered backup file. Cannot be recovered via transaction logs either.

On Windows, do you have automatic recovery turned on? Maybe you can recover the last mdf/ldf's and then attach those files. If it's hosted elsewhere, perhaps they have a backup.

Good luck!

thank you for your reply. i found that few of the views and stored procedures were not removed. i have fixed the database and recreated the other stored procedures manually :-)

Edited by sandeepani: n/a

0

might be a good idea to always take a backup before you do anything, even restoring. Sometimes, things just don't work out the way we plan.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.