You can't rollback a restore. Your only hope is that the SQL Server created
new files during the restore (e.g. backup was from a different server) and
the original deleted database files still exist on the drive. It's a long
shot but an undelete utility might allow you go recover those.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"san" <sh*******@gmail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
Hello,
i am in great trouble. I want to revert back to original state of
database before i performed restore database on my sql server 2K
Database. Accidently i didn't take backup of my Database and i did
restore, so is there any way to get the original state back of my
Database?
Any suggestion will be highly appriciated.
Regards,
S. Domadia.