Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-12-02 : 08:04:34
|
| Muhammad Qasim writes "i hav query that i was just taking the backup of the database n by mistake i just clicked restore as the wizards are similar so i just restored the database to 10days old backup n now i have no latest backup so how can i just undo this restore if u hav any idea of how to overcome this plz reply as early possible lookin for replies" |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-12-02 : 12:26:08
|
| You can't undo it (there's not even an unsupported way to do it - the data you overwrote isn't stored anywhere)RegardsPaul RandalLead Program Manager, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-02 : 12:57:20
|
At least you noticed ... I had a client do this and not notice for a month, and then they had to find all the data from the missing 10 days and re-key it  (Their database contained data which very seldom changed, which is why they didn't notice. Same thing though, the operator accidentally pressed RESTORE instead of BACKUP - albeit not in a SQL Server system ...)Sorry to say it, but you need a backup strategy. The Maintenance Wizard can be set to backup all "User Databases" - so as soon as you create a new database it will be in the backup strategy [daily / hourly / every minute!!! / whatever you choose]Kristen |
|
|
|
wiltech
Yak Posting Veteran
51 Posts |
Posted - 2005-12-02 : 14:23:01
|
I'm confuseed on this one.  Wouldn't you have to check the "Force restore over existing database" box on the options tab?Tony W |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-03 : 02:53:33
|
| Doesn't that relate to whether the original filenames of the backup match existing DB names, or not?Kristen |
|
|
|
|
|
|
undo Restore (Urgent)