<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 7,2000
»
Data Corruption
»
URGENT Help needed
12 posts, Page 1 of 2
1
2
»»
URGENT Help needed
Rate Topic
Display Mode
Topic Options
Author
Message
dpremi
dpremi
Posted Thursday, November 22, 2007 10:23 PM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, January 31, 2008 5:26 PM
Points: 8,
Visits: 22
Hi,
I am in a very rough situation and would like some help/advise.
My server crashed and I lost everything. Server was rebuilt and I tried to restore the .BAK file from tape. Noticed that backups were not going good as well. I found one .BAK file but when I restored it is reporting to be approx. 200Kb smaller than the size reported by windows. Backupexec restored 20785192 bytes but the size of the restored file is 20983171 bytes.
Anyway, when I try to restore .BAK file from enterprise manager system just sits there for hours. and when I check the file it is reporting as corrupt/incomplete.
Can anyone suggest any way to get data out of this file?
It is a really bad situation. I will be calling MS tomorrow but any suggestions are welcome.
Post #425130
GilaMonster
GilaMonster
Posted Friday, November 23, 2007 12:03 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Yesterday @ 4:11 PM
Points: 37,741,
Visits: 30,020
SQL 2000 or SQL 2005?
If you have a SQL 2005 server around (even if its just a desktop) try out the RESTORE DATABASE ... WITH CONTINUE_AFTER_ERROR
It's new functionality in SQL 2005 that allows a partial restore of a corrupt backup. You won't have everything, but you'll probably have more than you do now.
If that succeeds, bcp the data out and script out what objects you can
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #425149
dpremi
dpremi
Posted Friday, November 23, 2007 9:05 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, January 31, 2008 5:26 PM
Points: 8,
Visits: 22
Thanks for the quick response. I will give it a shot right now
Post #425307
dpremi
dpremi
Posted Friday, November 23, 2007 9:10 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, January 31, 2008 5:26 PM
Points: 8,
Visits: 22
Will a trial version work?
Post #425309
dpremi
dpremi
Posted Friday, November 23, 2007 10:53 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, January 31, 2008 5:26 PM
Points: 8,
Visits: 22
Oh, I forgot to mention that yesterday I used force restore and I manage to recover MDB and LDB files but I got some messages like bypassing recovery etc. around 90%. I have the MDB and LDB files but I cannot connect to the database
Post #425329
GilaMonster
GilaMonster
Posted Saturday, November 24, 2007 5:38 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Yesterday @ 4:11 PM
Points: 37,741,
Visits: 30,020
Is that on SQL 2000 or SQL 2005?
What's the state of the database? (suspect, recovering, offline, ...?)
There may be a way, but just so that you can copy the data out. Won't fix it.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #425410
dpremi
dpremi
Posted Saturday, November 24, 2007 10:52 PM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, January 31, 2008 5:26 PM
Points: 8,
Visits: 22
It is SQL 2000
I managed to bring the database in Emergency mode and have started to recover the data table by table by transfering the data.
Some tables are not transferring over as they are corrupt but I am trying my best to get whatever I can.
I am not sure if I can recover damaged tables or not? Any Ideas?
Post #425472
GilaMonster
GilaMonster
Posted Sunday, November 25, 2007 11:59 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Yesterday @ 4:11 PM
Points: 37,741,
Visits: 30,020
Probably not. What errors are you getting when trying to select from the tables?
If it were a corrupt DB, there might be a chance or reading the pages raw and decoding them by hand. Is really time consuming and requires a great deal of experience. Since the backup that you restored was corrupt, the data probably isn't there at all.
What did MS's product support say?
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #425500
dpremi
dpremi
Posted Sunday, November 25, 2007 7:34 PM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, January 31, 2008 5:26 PM
Points: 8,
Visits: 22
I managed to recover almost all of the 243 tables except for 8. These 8 tables have a lof of images and I am having difficulty restoring those.
I called microsoft on Fri and opened a case but have not heard back from anyone yet.
Post #425528
Brandie Tarvin
Brandie Tarvin
Posted Monday, November 26, 2007 4:57 AM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 12:39 PM
Points: 6,668,
Visits: 5,695
I take it you don't have any previous backups (to the one you're currently using) that might have these 8 tables on it?
There are some disk recovery services that might be able to pull the data you need from the server's old hard drive, but I don't know what the cost would be. Look in your local yellow pages under Data Recovery or Computer-Service & Repair.
Brandie Tarvin, MCITP Database Administrator, MCDBA, MCSA
Webpage
:
http://www.BrandieTarvin.net
LiveJournal Blog
:
http://brandietarvin.livejournal.com/
On
LinkedIn!
,
Google+
, and
Twitter
.
Freelance Writer:
Shadowrun
Latchkeys: Nevermore
,
Latchkeys: The Bootleg War
, and
Latchkeys: Roscoes in the Night
are now available on Nook and Kindle.
Post #425664
« Prev Topic
|
Next Topic »
12 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
