restore failed
-
Hi,
I got the following error when i tried to restore one my db:
"An Internal consistency error occured."
It seems that one table in that db corrupted to fix the problem I ran dbcc checkdb and checktable with repair option but no use.
Any suggestion will be appreciated.
SaNaZ
-
Doesnt sound good. You're restoring a backup made on the same server? What version of SQL and what sp? Can you access some of the tables?
Andy
-
I try to restore db on another servers with Sql7.0,sp4 and also sql2k,sp2but but the same result.I have access to all tables except one.I checked that table with dbcc checktable and got error (consistency error ) but i couldn't fix it with repair option. Table's data is very important to me .I save images on it which will be saved as binary data - using append chunk method-(and i also want to now is it correct to save images on table or is there any better method?)
again tanx a lot.
SaNaZ
-
If DBCC won't fix it there isn't a lot you can do. Tried an earlier back up maybe? If you cant fix it you'll have to drop the table, then recreate and do the best you can with your data.
Images in db are up to you, it's either that or a pointer to the file. The ADO stream offers a simpler way to do it than appendchunk, but the end result is the same.
Andy
-
Hi,
I've got a similar problem, but I've already used the backup file on another server and the restore works fine. Any suggestions.... I'm at my wits end and feeling the pressure.
DeltaKilo
-
Quick fix would be to use the mdf you restored on the other server, detach/copy/attach.
Andy
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply