Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

zhow to retrieve tables Expand / Collapse
Author
Message
Posted Thursday, July 12, 2012 2:31 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 6, 2012 1:33 PM
Points: 8, Visits: 29
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.
Post #1329162
Posted Friday, July 13, 2012 2:29 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 4:10 AM
Points: 5,221, Visits: 5,119
No backups? Why not?

What is the output from the following command
DBCC CHECKDB <Database Name> WITH NO_INFOMSGS, ALL_ERRORMSGS





Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1329293
Posted Friday, July 13, 2012 3:02 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 11:19 AM
Points: 40,428, Visits: 36,878
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 2008, MVP
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

Post #1329310
Posted Saturday, July 14, 2012 12:10 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, November 6, 2014 8:19 PM
Points: 121, Visits: 1,251
najeeb_kt2000 (7/12/2012)
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.


If you don't have backup, there is only one way to recover corrupt sql server database i.e. third party SQL repair software. These software repairs corrupt sql server database even you don't have backup of your database. You can easily search these software on Google like this: http://lmgtfy.com/?q=sql+repair+software


SQL Database Recovery Expert
Post #1329733
Posted Tuesday, July 17, 2012 12:12 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, November 9, 2014 12:08 PM
Points: 1,618, Visits: 1,553
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
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master: SQL Server 2008
Principal DBA: Outerwall, Inc.
Also available for consulting: SQL DBA Master
Post #1330965
Posted Tuesday, July 17, 2012 12:23 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 11:25 AM
Points: 866, Visits: 7,473
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
Post #1330970
Posted Friday, July 20, 2012 5:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 20, 2012 5:44 AM
Points: 2, Visits: 3
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.
Post #1332896
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse