.NetFoundry

Your SQL Server Community
Welcome to .NetFoundry Sign in | Join | Help
in Search
Home Blogs Forums Photos Downloads
.NetFoundry » SQL Server » SQL Server - TSQL » recovering droped table in SQL server (2000 /2005)

recovering droped table in SQL server (2000 /2005)

Last post 12-31-2007 6:28 by Manjula Perera. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 08-07-2007 7:20

    • wakil
    • Top 10 Contributor
    • Joined on 08-07-2007
    • Posts 3

    recovering droped table in SQL server (2000 /2005)

    Reply Contact

    Hi,

    One small query.

    I have accidently dropped one important table in one of the development database. Interestingly , we were yet to take any backup. In SQL server 2000, I suppose there are no ways to restore that table. Let me know if any one can help me. Is this feature available in SQL express/ sql 2005

    Regards,

    Wakil
    Filed under:

  • 08-26-2007 4:27 In reply to

    • Qazi
    • Top 10 Contributor
      Male
    • Joined on 07-29-2007
    • Dubai, UAE.
    • Posts 3

    Re: recovering droped table in SQL server (2000 /2005)

    Reply Contact

    Not possibble at all, restore either (full/partial/differential) is ONLY possibble provided you have the proper backup of database :)

  • 12-31-2007 6:28 In reply to

    Re: recovering droped table in SQL server (2000 /2005)

    Reply Contact

    No!!! Its possible if you have maintained your Log file properly. This reply may be too late but worth to keep in mind that you can recover your data by using the Log file if you've set it up properly. If you googled you could've found more information about recovering data from Log files in SQL Server 2000. Stick out tongue

    Regards,

    Manjul Perera 

     
    Filed under:
Page 1 of 1 (3 items)
Copyright .NetFoundry, 2007. All rights reserved.
Powered by Community Server (Non-Commercial Edition), by Telligent Systems