How to recreate lost tables.

Question

How to recreate lost tables.

najeeb_kt2000

Old Hand

Points: 398
More actions
July 10, 2012 at 4:09 am

#258584

My database tables are missing after a virus infection. How can I repair and recreate missed table from database folder.
when attached the .mdf and .ldf file, only dbo.sysdiagrams table is there.how can I retrieve the other tables.
please help me in the topic.
Thanx
July 19, 2012 at 3:46 am

This was removed by the editor as SPAM

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Restore from 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

Ant-Green SSC Guru Points: 113504 More actions · Answer 2

Based on the OP's first post on this here they dont have backup's, that is if its the same database in question.

Lowell SSC Guru Points: 323518 More actions · Answer 3

repair softwork doesn't seem to work when it comes to SQL Server, because the file is always open;

it's kind of like opening a word file;

you may edit for hours, but unless you saved it, if you erase stuff in the middle of the document, there's no where those changes are saved, and are not recoverable at all. neato software or not.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

db_expert_pradeep SSC Veteran Points: 294 More actions · Answer 4

Restore from backup:

1) Restore in dev enviroment

2) Script out the table

3) Create that table in Prod enviroment.

3) Import all data from Dev table.

davegeeit SSC Journeyman Points: 82 More actions · Answer 5

To recreate lost tables. use sql database repair software, many data recovery companies offering this software and also providing a free trial version of software. One of this utility you can download from here:

http://www.repairsqlserver.net

Thanks