Restore database error

I get ODBC SQLState error 42000 with message "internal
consistency error occured" while I restored database.
I tried MSSQL 7 and MSSQL 2000 with the same result.
This database was running without problem (MSSQL 7) and backup
was created "successfully".
I have another backups on the tape (for three years)
and all files act equally.
Any idea?
Perhaps the database was corrupt when you backuped it? Can you run a DBCC CHECKDB on the original
database (assuming you still have that online)?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Richard Horak" <richard_horak@.hotmail.com> wrote in message
news:eGWqC6k0EHA.3596@.TK2MSFTNGP12.phx.gbl...
> I get ODBC SQLState error 42000 with message "internal
> consistency error occured" while I restored database.
> I tried MSSQL 7 and MSSQL 2000 with the same result.
> This database was running without problem (MSSQL 7) and backup
> was created "successfully".
> I have another backups on the tape (for three years)
> and all files act equally.
> Any idea?
|||Corrupt? I think, that database, running and serving all requests
wouldn't be corrupt.
Original server is running now new OS and new SQL, return back is not
possible.....
Tibor Karaszi wrote:
> Perhaps the database was corrupt when you backuped it? Can you run a DBCC CHECKDB on the original
> database (assuming you still have that online)?
>
|||You can still have a corruption in the database even if you work against it. This is why you want to
run regular DBCC CHECKDB commands to see if you have any type of corruption (most often introduced
by hardware problems). I suggest you open a case with MS Support.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Richard Horak" <richard_horak@.hotmail.com> wrote in message
news:%23%23lMjD50EHA.3840@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Corrupt? I think, that database, running and serving all requests
> wouldn't be corrupt.
> Original server is running now new OS and new SQL, return back is not
> possible.....
> Tibor Karaszi wrote:
original[vbcol=seagreen]