Post reply

Table deleted

  • February 25, 2011 at 4:58 am

    #147404

    Hi All,

    If a table got deleted unfortunately from a database which is of 1TB in size, how to get back that table ?

    If we have the db backup we can restore it with other name and get that table using import and export.

    as this is a big Db how to deal this situation.

    Thank You.

    Regards,
    Raghavender Chavva

  • February 25, 2011 at 5:18 am

    #1291460

    you are correct, best thing to do would be to restore your backup to another databases and then copy the table across

  • February 25, 2011 at 5:38 am

    #1291470

    Do we have any other solution rather than restore and import\export, as it is a big database, it will take lot of time etc....

    Thank You.

    Regards,
    Raghavender Chavva

  • February 25, 2011 at 5:49 am

    #1291476

    There is a tool (from Redgate i think) that will allow you to do a virtual restore of the backup and then copy the table across.

    however I am not sure whether purchasing, installing and running this tool would be quicker overall..

  • February 25, 2011 at 7:57 am

    #1291540

    As yours is big database, i hope your DB have filegroups. You can find out the filegroup which belongs to your dropped table and use ' restore files and file groups' . this is an idea may be you can go thru the link below

    http://msdn.microsoft.com/en-us/library/aa196613(v=sql.80).aspx

    Regards

  • February 26, 2011 at 7:31 am

    #1291907

    We can restore the file group or files, but what about other tables which are in that file group. they will get effected ?

    If this table only resides on that file group or file we can easily recover our deleted table.

    Thank You.

    Regards,
    Raghavender Chavva

  • February 27, 2011 at 4:48 am

    #1292021

    i don't know if litespeed has 30 days free option, but litespeed does allow individual table restore.

  • February 27, 2011 at 10:52 am

    #1292048

    Raghavender (2/26/2011)

    We can restore the file group or files, but what about other tables which are in that file group. they will get effected ?

    If this table only resides on that file group or file we can easily recover our deleted table.

    No, file/filegroup restores don't work that way. You can't restore a filegroup to a time earlier than the rest of the database (read-only filegroups been an exception)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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