restore problem

HELLO ALL
I have a problem about DB restor:
I have a backup file of a DB about 600MB,when i try to restore on
another server running SQL SERVER 2000 with same sp3,it show me the error :
Microsoft SQL-DMO(ODBC SQLState:42000)
An internal consistency occurred.Contact Technical Support for
assistance.RESTORE DATABASE is terminating abnormally.
The original database has been erased,all i have is the backup file.
Anyone tell me how this happen and how to resolve it?
Thanks a lot.
Danny
Can you show us your RESTORE command?
"Danny Lu" <xlu2@.hotmail.com> wrote in message
news:elbc%23YlGFHA.2132@.TK2MSFTNGP14.phx.gbl...
> HELLO ALL
> I have a problem about DB restor:
> I have a backup file of a DB about 600MB,when i try to restore on
> another server running SQL SERVER 2000 with same sp3,it show me the error
:
> Microsoft SQL-DMO(ODBC SQLState:42000)
> An internal consistency occurred.Contact Technical Support for
> assistance.RESTORE DATABASE is terminating abnormally.
> The original database has been erased,all i have is the backup file.
> Anyone tell me how this happen and how to resolve it?
> Thanks a lot.
>
|||Sounds to me like you should do what the error say. There is a problem in the backup and you need MS
to possibly help you. Or go to the prior database backup (and possibly all subsequent log backups).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Danny Lu" <xlu2@.hotmail.com> wrote in message news:elbc%23YlGFHA.2132@.TK2MSFTNGP14.phx.gbl...
> HELLO ALL
> I have a problem about DB restor:
> I have a backup file of a DB about 600MB,when i try to restore on another server running SQL
> SERVER 2000 with same sp3,it show me the error :
> Microsoft SQL-DMO(ODBC SQLState:42000)
> An internal consistency occurred.Contact Technical Support for assistance.RESTORE DATABASE is
> terminating abnormally.
> The original database has been erased,all i have is the backup file.
> Anyone tell me how this happen and how to resolve it?
> Thanks a lot.
>