zhow to retrieve tables

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » Data Corruption (SS2K8 / SS2K8 R2) » zhow to retrieve tables

zhow to retrieve tables

Rate Topic

Display Mode

Topic Options

Author

Message

najeeb_kt2000

Posted Thursday, July 12, 2012 2:31 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, September 06, 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

anthony.green

Posted Friday, July 13, 2012 2:29 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

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

GilaMonster

Posted Friday, July 13, 2012 3:02 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 9:46 AM
Points: 37,728, Visits: 29,989

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

prettsons

Posted Saturday, July 14, 2012 12:10 AM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 2:50 AM
Points: 99, Visits: 1,035

najeeb_kt2000 (7/12/2012)

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 Smile

Post #1329733

Robert Davis

Posted Tuesday, July 17, 2012 12:12 PM

SSCommitted

Group: General Forum Members
Last Login: Sunday, May 19, 2013 8:09 AM
Points: 1,558, Visits: 1,396

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
Microsoft Certified Master: SQL Server 2008
Sr. Product Consultant and Chief SQL Server Evangelist @ Idera
My book: Pro SQL Server 2008 Mirroring

Post #1330965

David Webb-CDS

Posted Tuesday, July 17, 2012 12:23 PM

SSC Eights!

Group: General Forum Members
Last Login: Today @ 9:38 AM
Points: 825, Visits: 5,699

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

andrewmorton22

Posted Friday, July 20, 2012 5:54 AM

Forum 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 »

Permissions