SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


URGENT Help needed


URGENT Help needed

Author
Message
dpremi
dpremi
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
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.
GilaMonster
GilaMonster
SSC Guru
SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)

Group: General Forum Members
Points: 225901 Visits: 46321
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, MVP, M.Sc (Comp Sci)
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


dpremi
dpremi
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 22
Thanks for the quick response. I will give it a shot right now
dpremi
dpremi
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 22
Will a trial version work?
dpremi
dpremi
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
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
GilaMonster
GilaMonster
SSC Guru
SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)

Group: General Forum Members
Points: 225901 Visits: 46321
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, MVP, M.Sc (Comp Sci)
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


dpremi
dpremi
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
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?
GilaMonster
GilaMonster
SSC Guru
SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)SSC Guru (225K reputation)

Group: General Forum Members
Points: 225901 Visits: 46321
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, MVP, M.Sc (Comp Sci)
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


dpremi
dpremi
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
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.
Brandie Tarvin
Brandie Tarvin
SSC-Dedicated
SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)SSC-Dedicated (38K reputation)

Group: General Forum Members
Points: 38110 Visits: 9274
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 AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search