Friday, March 9, 2012

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 th
e backup and you need MS
to possibly help you. Or go to the prior database backup (and possibly all s
ubsequent 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 anoth
er 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.
>

No comments:

Post a Comment