Post reply

Drop tables

  • December 16, 2004 at 1:40 am

    #87345

    One of our administrator accidentally drop some tables from a database. Is there a way on how can we restore the data from the dropped tables.  Unfortunately, our backups is not updated so we can't just restore those. According to our administrator our last full backup is 1 week ago.

  • December 16, 2004 at 1:54 am

    #534101

    What recovery model do you use? If it is set to simple, I think you have just learned the hard way, why a good backup strategy is vital. Do you use some kind of log read third-party tool?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • December 16, 2004 at 1:57 am

    #534102

    ...oh, and I forgot, someone who calls himself "admin", needs to be more responsible. This should not happen. You might want to give him a more or less friendly slap on his hand. And probably remove EM from his computer.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • December 16, 2004 at 2:04 am

    #534105

    yeah, we already gave him one.

    I don't know what type recovery model they use. But according to the users they are not getting any result.  Can you suggest one?

    Actually, I was the Admin before. But since they replaced me with a new one, they always encounter errors regarding backup and recovery.  I only help them because of the users.  Because, before then i always make sure that my backup the previous night has no error.

     

     

     

  • December 16, 2004 at 2:07 am

    #534107

    What does this return?

    select databasepropertyex('your db','recovery')

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • December 16, 2004 at 10:22 am

    #534187

    Building on what Frank said about recovery model, if it's "Full", you can do a log backup now, restore last week's full backup with NORECOVERY, then restore the log backup with RECOVERY.

    Greg

    Greg

  • December 16, 2004 at 4:22 pm

    #534260

    thank you to all of you.

    We already recovered the data last night using recover log stored proc.

    thank you for your time and effort.

     

     

  • December 17, 2004 at 2:53 am

    #534292

    Glad to hear that. I guess next step will be to analyze what happen exactly and make sure it will not happen again.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply