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
643 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
161 Posts

Posted - 01/28/2013 :  00:35:13  Show Profile  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
  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.06 seconds. Powered By: Snitz Forums 2000