I want to revert back to original state of database before i performed restore database

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • san
    #1

    I want to revert back to original state of database before i performed restore database

    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.

    Tags: None
    • Greg D. Moore \(Strider\)
      #2
      Re: I want to revert back to original state of database before i performed restore database


      "san" <shdomadia@gmai l.comwrote in message
      news:1163592758 .514890.277030@ h48g2000cwc.goo glegroups.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?
      >
      If I understand you correctly, no.

      You restored a backup over a copy of your database?

      That completely overwrites it.

      Any suggestion will be highly appriciated.
      >
      >
      Regards,
      S. Domadia.
      >

        Comment

        • Dan Guzman
          #3
          Re: I want to revert back to original state of database before i performed restore database

          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@gmai l.comwrote in message
          news:1163592758 .514890.277030@ h48g2000cwc.goo glegroups.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.
          >

            Comment

            Previous template Next
            Working...