You are here: Re: I want to revert back to original state of database before i performed restore database « MsSQL Server « IT news, forums, messages
Re: I want to revert back to original state of database before i performed restore database

Posted by Dan Guzman on 11/15/06 13:45

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" <shdomadia@gmail.com> wrote in message
news:1163592758.514890.277030@h48g2000cwc.googlegroups.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.
>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация