Database Restore - SQL Server Forums

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."

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

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

livcyxingfoe
Starting Member

3 Posts

Posted - 2013-04-11 : 05:58:39

unspammed

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 } ]
}
]

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/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources