Home > IT Answers > SQL Server > How to retrieve tables?
DatabaseRecovery
35 pts.
 How to retrieve tables?
SQL Server 2005, SQL Server database
My SQL Server 2005 database get corrupted because of a 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.

Software/Hardware used:
Windows XP, Sql server Express
ASKED: July 12, 2012  8:36 PM
UPDATED: July 13, 2012  6:17 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question. Michael Tidmarsh   11,400 pts. , DatabaseRecovery   35 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Just a comment:  You dont have any other backups

carlosdl
 63,535 pts.
 

When you say no tables are showing now, does that mean that you can not see them when you expand the tables tab in SSMS, or are you not seeing them when you query sysobjects? Can you run a select against any of your tables?
Why do you not have a backup?

Colin Smith
 845 pts.