any way to rollback dbase

Hi just wondering if there is anyway to roll back a database? For example
the last time the database was backed up say 3 months ago and a restore was
done yesterday. Just wondering if there is anyway to undo the restore?
Thanks.
Paul G
Software engineer.
No, a database restore can't be undone because all data in the target are
replaced during the restore.
Hope this helps.
Dan Guzman
SQL Server MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:9A8E7FFE-2DFA-4FAC-AE0F-2BB8BF026E1C@.microsoft.com...
> Hi just wondering if there is anyway to roll back a database? For example
> the last time the database was backed up say 3 months ago and a restore
> was
> done yesterday. Just wondering if there is anyway to undo the restore?
> Thanks.
> --
> Paul G
> Software engineer.
|||"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:9A8E7FFE-2DFA-4FAC-AE0F-2BB8BF026E1C@.microsoft.com...
> Hi just wondering if there is anyway to roll back a database? For example
> the last time the database was backed up say 3 months ago and a restore
> was
> done yesterday. Just wondering if there is anyway to undo the restore?
> Thanks.
> --
> Paul G
> Software engineer.
Sure -- this can be easily done.
Assuming you have a backup you took immediately
prior to the restore.
What's that? You don't have one? Well, why not?
Chalk this one up as a lesson learned.
Really, there's no way without another backup
that was taken just prior to the restore.
|||Hi,
No you cant do a recovery back if you restore a full database backup.
Here after please do a backup and keep yourself safe before restoring.
Thanks
Hari
SQL Server MVP
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:9A8E7FFE-2DFA-4FAC-AE0F-2BB8BF026E1C@.microsoft.com...
> Hi just wondering if there is anyway to roll back a database? For example
> the last time the database was backed up say 3 months ago and a restore
> was
> done yesterday. Just wondering if there is anyway to undo the restore?
> Thanks.
> --
> Paul G
> Software engineer.
sql