SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Database Restore
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

virendra_sama
Starting Member

India
1 Posts

Posted - 01/12/2013 :  02:32:34  Show Profile  Reply with Quote
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

USA
649 Posts

Posted - 01/12/2013 :  11:50:13  Show Profile  Reply with Quote
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."

Edited by - Jeff Moden on 01/12/2013 19:02:21
Go to Top of Page

davegeeit
Starting Member

11 Posts

Posted - 01/16/2013 :  02:50:29  Show Profile  Reply with Quote
Checkout this reference would be help you.

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

Thanks
Go to Top of Page

prett
Posting Yak Master

USA
203 Posts

Posted - 01/28/2013 :  00:35:13  Show Profile  Visit prett's Homepage  Reply with Quote
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

China
3 Posts

Posted - 04/11/2013 :  05:58:39  Show Profile  Reply with Quote
unspammed
Go to Top of Page

elliswhite
Starting Member

36 Posts

Posted - 05/01/2014 :  06:47:09  Show Profile  Reply with Quote
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

USA
37133 Posts

Posted - 05/01/2014 :  12:00:49  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000