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
sandeepani
0
Newbie Poster
Recommended Answers
Jump to PostI'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 …
All 3 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.