InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 23:33:59 GMT20http://www.sqlservercentral.com/Forums/Topic1327389-2893-1.aspxTo 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.netThanksWed, 05 Dec 2012 00:10:51 GMTdavegeeithttp://www.sqlservercentral.com/Forums/Topic1327389-2893-1.aspxRestore from backup:1) Restore in dev enviroment 2) Script out the table3) Create that table in Prod enviroment.3) Import all data from Dev table.Thu, 06 Sep 2012 02:28:56 GMTdb_expert_pradeephttp://www.sqlservercentral.com/Forums/Topic1327389-2893-1.aspxrepair 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.Thu, 19 Jul 2012 06:28:43 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1327389-2893-1.aspxBased on the OP's first post on this [url=http://www.sqlservercentral.com/Forums/Topic1329162-2893-1.aspx]here[/url] they dont have backup's, that is if its the same database in question.Thu, 19 Jul 2012 03:52:42 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1327389-2893-1.aspx[quote][b]najeeb_kt2000 (7/10/2012)[/b][hr]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[/quote]Agree with GilaMonster first try to restore database from updated backup. If you don't have backup then try third party SQL repair software. You can easily Google these software just like this:[url=http://lmgtfy.com/?q=sql+repair+software]http://lmgtfy.com/?q=sql+repair+software [/url]Thu, 19 Jul 2012 03:46:50 GMTprettsonshttp://www.sqlservercentral.com/Forums/Topic1327389-2893-1.aspxRestore from backup.Tue, 10 Jul 2012 04:15:17 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1327389-2893-1.aspxMy 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.ThanxTue, 10 Jul 2012 04:09:27 GMTnajeeb_kt2000