zhow to retrieve tables

  • My Sql server 2005 Database get corrupted coz of some virus infection. No tables are showing now. My database folder contains .mdf, .ldf and file (3 files) can I retrieve my tables using one of this. Any solution please? I don't have any other backups.

    Please get a solution.

  • No backups? Why not?

    What is the output from the following command

    DBCC CHECKDB <Database Name> WITH NO_INFOMSGS, ALL_ERRORMSGS

  • If you have no backups then you very likely have lost any data that was in those tables. There are no magic recovery tricks, if the tables are gone, they're gone and the only way to get them back would be to restore a backup.

    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
  • This was removed by the editor as SPAM

  • Before you spend money on repair software, be aware that if the data is gone, no software program may be able to recover it. It can't recover what's not there. There is a very limited use case where these programs are actually effective. If you're desparate, it may be worth trying, but you should be aware ahead of time that it probably won't work.

    Also, all tables not showing up sounds a lot like a permissions issue. Are you sure the tables are gone and that it's not a case of you don't ahve sufficient privileges?


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

  • What are the names of the files you have left? Does the SQL Server start? What error messages are you getting? Are all the logins still intact? Can you see the database and the tables aren't there or can you not see the database at all?


    And then again, I might be wrong ...
    David Webb

  • Reasons like server crashing, system software malfunction, hardware failure and virus infection can easily cause corruption in SQL Server database. When SQL database corrupts, vital data get lost and important business work stops. To handle such situation, database needs to be recovered by some special methods as manual recovery is not possible in severe database corruption issues. There are several third party SQL recovery tools available that can easily repair SQL database and retrieve the data. Don't go for buying the software instantly download the demo version first and check if the software works as intended or not. I have searche one tool for you download it and check if it works http://www.nucleustechnologies.com/sql-recovery.html . I have used other products from the same vendor.

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

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