Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Database Restore

Author  Topic 

virendra_sama
Starting Member

1 Post

Posted - 2013-01-12 : 02:32:34
My table is dropped and recreate script but table is contain very crucial record and want to back database
plz help i urgent

veeru

Jeff Moden
Aged Yak Warrior

652 Posts

Posted - 2013-01-12 : 11:50:13
Unless you have a recent backup, that table is pretty much toast. Sorry.

So, do you have a recent backup?

--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for "Row By Agonizing Row".

First step towards the paradigm shift of writing Set Based code:
"Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

When writing schedules, keep the following in mind:
"If you want it real bad, that's the way you'll likely get it."
Go to Top of Page

davegeeit
Starting Member

11 Posts

Posted - 2013-01-16 : 02:50:29
Checkout this reference would be help you.

http://support.microsoft.com/kb/320785

Thanks
Go to Top of Page

prett
Posting Yak Master

212 Posts

Posted - 2013-01-28 : 00:35:13
You can only repair your corrupt table if you have updated backup of your database. If you don't have backup then follow this article:
http://data-base-recovery.blogspot.in/2012/09/how-to-restore-sql-server-database-with.html
Go to Top of Page

livcyxingfoe
Starting Member

3 Posts

Posted - 2013-04-11 : 05:58:39
unspammed
Go to Top of Page

elliswhite
Starting Member

36 Posts

Posted - 2014-05-01 : 06:47:09
Try to use DBCC CHECKTABLE command:
DBCC CHECKTABLE
(
table_name | view_name
[ , { NOINDEX | index_id }
|, { REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST | REPAIR_REBUILD }
]
)
[ WITH
{ ALL_ERRORMSGS ]
[ , EXTENDED_LOGICAL_CHECKS ]
[ , NO_INFOMSGS ]
[ , TABLOCK ]
[ , ESTIMATEONLY ]
[ , { PHYSICAL_ONLY | DATA_PURITY } ]
}
]
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-05-01 : 12:00:49
quote:
Originally posted by elliswhite

Try to use DBCC CHECKTABLE command:
DBCC CHECKTABLE
(
table_name | view_name
[ , { NOINDEX | index_id }
|, { REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST | REPAIR_REBUILD }
]
)
[ WITH
{ ALL_ERRORMSGS ]
[ , EXTENDED_LOGICAL_CHECKS ]
[ , NO_INFOMSGS ]
[ , TABLOCK ]
[ , ESTIMATEONLY ]
[ , { PHYSICAL_ONLY | DATA_PURITY } ]
}
]




How does DBCC CHECKTABLE help when the table has been dropped?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -